Alteryx Designer Desktop Discussions

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

Pulling records based on Max ID

MROGK
8 - Asteroid

I would like to get the Sales & Profit data ONLY for max Record ID & max Cycle ID. Can someone help? Thank you

 

RECORD IDCYCLE IDSALES $PROFIT$
183010
2104523
385634
1112311
283112
3106745
1118934
283412
3102311
111128
2107856
389078
2 REPLIES 2
BrandonB
Alteryx
Alteryx

Is this what you are looking for?

 

record and cycle ID.png

MROGK
8 - Asteroid

Thank you very much.

Labels