In case you missed the announcement: Alteryx One is here, and so is the Spring Release! Learn more about these new and exciting releases here!

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