Reading a file saved from previous day (as csv) checking it for duplicates account etc..

Question

Morning,

I have a workflow which runs for previous day (daily) and currently saves accounts and their status's (e.g. 'A' for active) in an excel file in a designated location.

When the workflow is ran again, just before it saves and overwrites the file, I want it to check the already saved file against the current data that has just ran, for matching account and status and if any has been found exclude those accounts from current data then make it overwrite the file and save.

What is the best way to do this?

Many thanks in advance

binu_acs · Answer

@chiragpatel_1 Few questions, I suppose the input file for this workflow is from yesterday's date, and what about the output file saved on which date? When you run the second time are you going to use the same file or a different file? When you run the second time the 1st run output file and the second input file need to be compared then what records need to be included? There will be 3 sets of records 1. Matching records (exist in both files), 2. Records only exist in the input file 3. Record only in the output file (new records)

chiragpatel_1 · Answer

Any update?

chiragpatel_1 · Answer

Thank you but will it be possible for you to give me an example workflow, fairly new to Altreyx, it would be massive help