Alteryx Designer Desktop Discussions

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

Help summarizing by item with more than one matching result

moblender
7 - Meteor

Hi I have the following table below and would like to re-order this so that plant(s) are on one line. Second table in red is how I'd like it to read. Any help would be great!

MaterialRatio 1Ratio 2Plant 1Plant 2
A20  2
A 801 

 

MaterialRatio 1Ratio 2Plant 1Plant 2
A20 80 12
2 REPLIES 2
binuacs
21 - Polaris

@moblender use a summarize too for this

 

binuacs_0-1643642528506.png

 

messi007
15 - Aurora
15 - Aurora

@moblender,

 

Another methode :

With that if you have a new column it will appear in the output without modifying the workflow.

messi007_0-1643643540880.png

 

Attached the workflow,

Regards,

 

Labels
Top Solution Authors