Join the Alteryx Community’s Maveryx Summer Cup event! Compete, network with others, and earn your gold through a series of challenges from July 24th to August 11th. Learn more about the event here.

Alteryx Designer Desktop Discussions

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

Selecting the lowest number by grouping

SH_94
11 - Bolide

Dear community,

 

May i know how we can build the proper workflow that able to select the lowest number by grouping them item type so that the result as below

 

Input

ItemNumber
PKD7
PKD8
PKD10
PKD11
PKD9
PKD3
PKD2
PKD1
KOF2

 

 

Output

ItemNumber
PKD1
KOF2

 

Thank you.

 

1 REPLY 1
DataNath
17 - Castor

Hey @SH_94 - you just need to use a Summarize here and Group by Item before using the Min function!

 

DataNath_0-1657183390732.png

 

Labels