Cross checking two files and deleting identical data

[AttilaBalint]

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,

[alexnajm]

It sounds like a Join tool will complete this, joining on the ID field and then taking the R output from that Join tool!