Not sure if I'm even close but here is the scenario:
I have multiple Work Orders in a process, some can have 1 to 10 work orders before it is closed. In those work orders I collect Labor and Parts information, each in their own table. At the end of the process I would like to take those tables and combine them into one to create an invoice.
What I tried to do was create the multivalue tokens I need, and then append them for each table. Then do a "For Each" activity and dump into a spreadsheet. This works fine, however, it inserts them into the spreadsheet based on how they were appended to the token (duh).
What I want to do is group the Labor and Parts based on the WO # and then insert into the spreadsheet. When I do a For Each activity and format the tokent to sort by WO #, it only sorts that WO # and none of the other tokens. Can I accomplish this without creating a SQL DB and calling it?