Let’s talk Alteryx Copilot. Join the live AMA event to connect with the Alteryx team, ask questions, and hear how others are exploring what Copilot can do. Have Copilot questions? Ask here!
Start Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Merging Data

angelique_martin
7 - Meteor

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. 

 

 

angelique_martin_0-1632777946772.png

 

4 REPLIES 4
Qiu
21 - Polaris
21 - Polaris

@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
7 - Meteor

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. 

 

angelique_martin_0-1632934041504.png

 

Luke_C
17 - Castor
17 - Castor

Hi @angelique_martin 

 

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

angelique_martin
7 - Meteor

Thank you @Luke_C that worked. 

Labels
Top Solution Authors