02-14-2023 11:11 AM
I am attempting to get a list of employees that are in a csv file that do NOT appear in a lookup table.
The steps done and working:
- Parse CSV and Create a List - CSV has 9 Records
- Retrieve all records from the Lookup List - Lookup List has 2 Records
- Created a logger step formula with a where.not formula to compare a field in the CSV to a field in the Lookup List. Log Message correctly returns the 7 employees that are in the CSV and not in the list.
I now want to now process these 7 records however I can not use the Repeat Action as it requires a list and will not allow me to use the output from the message.
Does anyone have a recommendation how I can get this information into a list so it can be processed?
Thanks in Advance for any Advice!
Solved! Go to Solution.
02-15-2023 06:28 AM
Vote for this idea, which would allow you to define a List variable and set the "Items source list" to be a similar step as you put in the Logger step. It mentions a workaround for now
02-15-2023 06:28 AM
Vote for this idea, which would allow you to define a List variable and set the "Items source list" to be a similar step as you put in the Logger step. It mentions a workaround for now
02-20-2023 08:52 AM
I would recommend using a Collection to ingest your data, then you can query it using SQL syntax and then results will be in a list that you loop over... 🙂
--
Patrick
Workato Consultant
patrick@infranet.com