Hi, I'm hoping the community can help me with this little issue.
I have a large data set and some of the rows are common and should be added or merged to form one record. I've an simple example below:
I need to combine the highlighted rows into one as well as any other common rows elsewhere in the file. Anyone have and idea what tool could help?
Solved! Go to Solution.
Hi @Ro2 you should be able to do this with the Summarize tool.
Group By ORG, Type, Part Number and Date, and Sum the Amt field.
Hope that helps.
Hi @Ro2,
I have created a mock workflow for you:
Input:
Oputput:
Workflow:
If this was helpful please mark it as an answer!
Solved it with summarize tool.
Thanks Mark
Thanks Emil