Selecting the lowest number by grouping

[SH_94]

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

Item	Number
PKD	7
PKD	8
PKD	10
PKD	11
PKD	9
PKD	3
PKD	2
PKD	1
KOF	2

Output

Item	Number
PKD	1
KOF	2

Thank you.

[DataNath]

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