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 |
Solved! Go to Solution.
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.
Thanks apathetichell. its a big help.
Thanks binuacs. its a big help.

