CSV Subset Removal in a Pagelist
I have an issue in an activity which is supposed to output a Pagelist of CSV values. Each page of the pagelist contains a comma separated list of IDs, as shown below:
pxResults:
pxResults(1):
pyName: O1,O2,O3,O4,O5
pxResults(2):
pyName: O1,O2,O3,O4
pxResults(3):
pyName: O1,O2,O4
pxResults(4):
pyName: O1,O6
What is the least performance intensive way to get rid of all subsets in the pagelist (If [O1,O2,O3] is somewhere on the pagelist, pages comprised of [O1,O2], [O1,O3], and [O2,O3] should not show up)? In the above example, only pxResults(1) and pxResults(4) should remain after performing this function, as they are not fully contained by any other page.
Thanks,
Matthew
Accepted Solution
Pegasystems Inc.
US
I don't think if you can avoid scanning each individual CSV value in every Page in the page list.
- Create a Set.
- Iterate through each page in the page list.
- Read each CSV value in the page
- Add the CSV value to the set if the set does not contain the value. Mark this page for return as it has added new value to the Set.
- If CSV is found in the set, continue to scan the CSV list till the end
Infosys
US
Thanks! I was hoping that there was an OOTB way to avoid splitting each CSV into its component parts, but I can understand why. This may become an issue if the number of elements grows too large, so perhaps using pagelists/sets instead (meaning a pagelist inside a pagelist) and simply converting the output to a CSV would be more viable.
Thanks,
Matthew