Max() for each order-no

[Borisham]

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

[ChrisTX]

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]

Hi @Borisham,

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

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]

Thanks your help guys.

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

[Borisham]

Thanks to your help guys.

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

[Borisham]

Thanks to your help guys.

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

[Jonathan-Sherman · Accepted solution]

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?

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