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.
Solved! Go to Solution.
@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.
Instead of having Include MF, WR, and CS as 'group by', use 'max' as the aggregation method.
Thank you @Luke_C that worked.