Alteryx Connect Discussions

Find answers, ask questions, and share expertise about Alteryx Connect.
SOLVED

How to combine similar rows ??

jai_patel_02
6 - Meteoroid

Hello!! 

 

How to combine similar rows in Alteryx ?? 

jai_patel_02_1-1658596213455.png

In the output above I want to combine similar Material Description and sum up the qty & amount what's the best way to do it?? 

Thanks
Jai

4 REPLIES 4
IraWatt
16 - Nebula

Hey @jai_patel_02,

I would use the Summarize tool to do this be grouping on Material Description and Summing qty & amount:

IraWatt_0-1658607536971.png

There's a really quick and easy video on summarizing here on the community: Summarizing Data - Alteryx Community

 

Any questions or issues please ask! 
Hope that Helps

Ira Watt
Technical Consultant
Watt@Bulien.com 

IraWatt
16 - Nebula

Also @jai_patel_02, for quicker answers I would recommend posting questions on the Alteryx Designer Discussions - Alteryx Community board not the Connect Discussions 😄.

jai_patel_02
6 - Meteoroid
My bad
Ivan569
5 - Atom

Thank you for the explanation.