Output the record ID if it is present in the most recent file.

[RoxanneR]

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.

[davidskaife]

Hi @RoxanneR 

You can achieve this using a Join tool followed by the Union tool

[nagakavyasri]

@RoxanneR you need to compare 2 periods from the files to know the latest period

[kamal03]

 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