Let’s talk Alteryx Copilot. Join the live AMA event to connect with the Alteryx team, ask questions, and hear how others are exploring what Copilot can do. Have Copilot questions? Ask here!
Start Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

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

RoxanneR
7 - Meteor

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.

3 REPLIES 3
davidskaife
14 - Magnetar

Hi @RoxanneR 

 

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

 

Capture.PNG

nagakavyasri
12 - Quasar

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

 

Capture16.PNG

kamal03
9 - Comet

 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

 

Labels
Top Solution Authors