topic Re: Compare CSV to Lookup Table in Workato Pros Discussion Board

Compare CSV to Lookup Table

vascoeagles — Tue, 14 Feb 2023 19:11:08 GMT

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!

Re: Compare CSV to Lookup Table

mppowe — Wed, 15 Feb 2023 14:28:48 GMT

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&section=requests

Re: Compare CSV to Lookup Table

patrick-steil — Mon, 20 Feb 2023 16:52:40 GMT

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