Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.
Free Trial

Alteryx Designer Desktop Discussions

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

summarize on last?

becki
8 - Asteroid

hi folks, I want to check on the most efficient way to do this.  i need to find the latest date of revisions of a purchase order, to compare to the latest payment, on the PO.  i did a sort ascending, on both the PO and the revision number, then do summarize, take last of PO and revision number.  does this need to be done in two steps?  ( i ask because in ACL, it would be one summarize command).  thanks

 

becki kain

 

6 REPLIES 6
MarqueeCrew
20 - Arcturus
20 - Arcturus

@becki,

 

I'm sdrawkcab in my thinking.  I might approach this by use of different tools.

 

SORT: PO (asc), Rev# (Dec).

SAMPLE: Group by PO.  Get 1st record.

 

That's my take.

 

Cheers,

Mark

Alteryx ACE & Top Community Contributor

Chaos reigns within. Repent, reflect and restart. Order shall return.
Please Subscribe to my youTube channel.
becki
8 - Asteroid

still two steps though.  is that any faster? just curious on the speed of different commands.

 

and thanks!

becki
8 - Asteroid

and thanks for the response!  I didn't know there was a Detroit group!  I just joined

 

pcatterson
11 - Bolide

You should be able to do it with just the summarize.  If your dates are correct, you can use max to find the latest date.  Is that what you mean?

MarqueeCrew
20 - Arcturus
20 - Arcturus

@pcatterson is right that you can in one step

 

Groupby PO

Max Rev #

 

That is one step.

Alteryx ACE & Top Community Contributor

Chaos reigns within. Repent, reflect and restart. Order shall return.
Please Subscribe to my youTube channel.
becki
8 - Asteroid

well that's cool!  thanks!

 

Labels
Top Solution Authors