group and concatenate

Johmz

Need help to group data and concatenate if different input

Input

STATE	PRODUCT	SORT
Florida	Apple	Box
Florida	Orange	Bag
Ohio	Apple	Box
Ohio	Apple	Bag
Kansas	Apple	Bag
Kansas	Orange	Bag
Nevada	Apple	Box
Nevada	Orange

Output

STATE	PRODUCT	SORT
Florida	Apple/Orange	Box/Bag
Ohio	Apple	Box/Bag
Kansas	Apple/Orange	Bag
Nevada	Apple/Orange	Box

apathetichell

summarize tool. group by state. concatenate product. concatenate sort. / is your delimiter.

although in your case - it might make more sense to split this up into two streams. do two summarizes in each (group by/group by and then group by/concatenate) (to get each unique sub entry of sort/product) - and then rejoin on state after the concat. you can filter out blank fields if you want prior to concatenating.