How to store csv file to compare records and add a new column

[former_member10122]

Hi Team,

I have a below requirement.

Interface will execute weekly once where I query a DB and pull the records and write a csv file.

1. I want to store the last week file in a location and compare it with current week run file.

2. Based on Unique ID value and its status, I want to add a Action column in the current week file which will determine whether the record is Create/Update/Delete.

a) If the ID value doesn't exist in Last week file and if it exist in current file, then its Create

b) If the ID value exist in Last week file and also exists in current file, then its Update

c) If the ID exists and status in Inactive, then its Delete

How to achieve this ?

Thanks,

Varun