Merging Data

[angelique_martin]

Hi Alteryx community,

I'm currently trying to determine how to merge some data from different rows together. I did use the Summarize tool to group by Agreement and Supplier number; however, I'm still getting multiple rows. I also want to sum the total amounts for that specific supplier. Below is a screenshot of what I'm currently doing in Alteryx. Any help will be greatly appreciated. 

[Qiu]

@angelique_martin 
If you want one row for each supplier, you shoud not include the fields like "Include_WF", "Include_WR" and "Include_Include CS" in the summarize tool.

[angelique_martin]

Thanks for your response Qui. However, I am trying to get my data to look like the screenshot I have attached below. Do you have any suggestions on how to do this? I've also attached the same picture as well. 

[Luke_C · Accepted solution]

Hi @angelique_martin 

Instead of having Include MF, WR, and CS as 'group by', use 'max' as the aggregation method.

[angelique_martin]

Thank you @Luke_C that worked.