Compare CSV to Lookup Table

[vascoeagles]

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!

[mppowe · Accepted solution]

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

https://ideas.workato.com/app/#/case/187864?currentProductId=caf1efdf-1d7e-4b7b-aeb9-28e4b0f4b25c&se...

[patrick-steil]

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