I have a list of product IDs, the current spend of each product, the annual budget for each product and the Department who have purchased the products:
I want to only keep the first occurrence of the Annual Budget amount for each Product ID so I can work out the correct value for the total annual budget amount if I need to group and sum the records i.e. I want the output to look like this:
Please can someone help me with this?
Thanks in advance!
Hi @JPassion13
You can get rid of the subsequent Budget amounts by using a multirow tool with the following config
You can also get the summaries without having to remove the subsequent Budget rows by using the First operator in the Summarize tool
Both of these options are included in the attached workflow.
In future, if you have a large amount of input data, please include a sample file or at least a text table as apposed to an image. It makes it much easier for people to help you.
Dan