How to combine similar rows ??

[jai_patel_02]

Hello!! 

How to combine similar rows in Alteryx ?? 

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

[IraWatt · Accepted solution]

Hey @jai_patel_02,

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

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]

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]

My bad