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

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.

Workflow

Developer Tools

Input

Accepted answers

All comments

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

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

compare periods.yxmd

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

Output the record ID.yxzp

Output the record ID.png

Quick Links

Tags

This months top contributors

atcodedog05 19598

Qiu 15867

MarqueeCrew 13708

apathetichell 13703