Hello,
Trying to find an efficient way to take the results from a dbxlookup - where a single userID would bring back more than one record, - into multiple multiple row output.
Example: I have a list of 10 userIDs and run a dbxlookup against a d/b containing login/logout times. I want to see how many times each userID logged in/out, as well as their first login/out of the month, and their most recent login/out.
I will supply my SPL shortly, but I wanted to see if anyone might have experienced this issue in the past and has a solution.
Thanks and God bless,
Genesius
