Hi, I need a little help with my workflow-
I have a set of 12 inputs divided by months and new files will be adding up monthly
What I need to achieve is -
I want to only output the record ID if it is present in the most recent file.
If record ID is in the most recent month data - I want to keep it
If record ID was present in previous months but not in the most recent one - I dont want it to be included
File 1
Record ID | Reporting period |
1012 | 2023-11-02 |
File 2
Record ID | Reporting period | ||
1012 | 2023-10-18 | ||
1013 | 2023-10-16 |
Expected output
Record ID | Reporting period |
1012 | 2023-11-02 |
Thanks for help.
Hi RoxanneR
Another way of solving this problem is by comparing 2 files id and then comparing the dates. Please accept this solution if this fits your needs.
Thanks