Merging Data

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.

Sample Data.PNG

Workflow

Common Use Cases

Accepted answers

Luke_C

Hi @angelique_martin

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

All comments

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.

Sample Output.PNG

Luke_C

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.

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703