Hello,
I have a report that I create every month and I need to crosscheck it with the previous one and delete those rows that were already reported in the previous month. This is a report about new hires which I make in the middle of the month (but the exact date differs month by month.)
I have created an automation that takes the raw data and filters for the current and the previous month and now I would need an automation that would take the two files and crosscheck them and delete every row that appears in both reports. Is that possible with Alterysx?
Here's an example:
Feb Report March data:
ID Name Start Date ID Name Start date
1001 Tom 01-02-2023 1001 Tom 01-02-2023
1002 Kim 07-02-2023 1002 Kim 01-02-2023
1003 Kate 24-02-2023
1004 Tim 01-03-2023
1005 Phil 01-03-2023
And this is what I would need to see in the output after the two files are crosschecked:
ID Name Start date:
1003 Kate 24-02-2023
1004 Tim 01-03-2023
1005 Phil 01-03-2023
Is tis possible to achieve? Can anybody help me with this?
Many thanks,
