Alteryx Designer Desktop Discussions

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

Max() for each order-no

Borisham
8 - Asteroid

Hello guys,

 

I need to get for each order-id(V_string) the highest number of colour-id(int32) and the max date(date)... how could I do that ?

 

Thanks for help

 

Borisham_1-1590604202746.png

 

5 REPLIES 5
ChrisTX
15 - Aurora

Use the Summarize tool.  Group by Order id.  Max Colour id.  Max Date.

 

Beginning users can find some great information on the Alteryx web site under Academy.

  • Try Learning Paths
  • Try Interactive Lessons
  • Under the link for Videos, click the pinned post for Video Training Index, and look at the videos with Difficulty = Beginner
  • Under Weekly Challenge, click the pinned post for Weekly Challenge Index & Welcome, and try the challenges with Level of Difficulty = Beginner

 

Jonathan-Sherman
15 - Aurora
15 - Aurora

Hi @Borisham,

 

In a similar way to @ChrisTX i'd use a summarise tool, thought i'd mock up an example:

 

Jonathan-Sherman_0-1590604838674.png

 

If this solves your issue please mark the answer as correct, if not let me know! I've attached my workflow for you to download if needed.

 

Regards,

Jonathan

 

Borisham
8 - Asteroid

Thanks your help guys.

 

Can you explain to me a bit why you have chose Max for name and address ?

Borisham
8 - Asteroid

Thanks to your help guys.

 

Can you explain to me a bit why you have chosen Max for name and address?

Jonathan-Sherman
15 - Aurora
15 - Aurora

Hi @Borisham,

 

I'm going to amend my solution as i don't think it works properly as expected to go a slightly different way. Summarise on Order id and take max color id and max date. Join this back to the original dataset on the three fields to only keep those rows. Hopefully this makes a little more sense?

 

Jonathan-Sherman_1-1590606754484.png

 

If this solves your issue please mark the answer as correct, if not let me know! I've attached my workflow for you to download if needed.

 

Regards,

Jonathan

 

 

Labels