Missed the Q4 Fall Release Product Update? Watch the on-demand webinar for more info on the latest in Designer 24.2, Auto Insights Magic Reports, and more!

Alteryx Designer Desktop Discussions

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

Formula

jlfromm
8 - Asteroid

I have a set of data that have the same Recip ID for month 1, 2, 3.   I want to create a formula that will just select the newest inform from that recip if. 

 

Example If Recp id -001A has inform for month a 1 and 2 then i want the infor on the from month 2 

               IF Recp ID - 002B has information for month 1, 2, and 3 then I want information on month 3

2 REPLIES 2
Felipe_Ribeir0
16 - Nebula

Hi @jlfromm 

 

It would be better to see the exact table for input/output.

 

If your input is like this:

 

Felipe_Ribeir0_1-1666025514305.png

 

 

Then the attached workflow will do the job.

 

Felipe_Ribeir0_0-1666025451241.png

If it is not, please paste/attach your input/expected output here.

 

jlfromm
8 - Asteroid

Thank you this will work

Labels
Top Solution Authors