Hi guys, (Updated the post sorry wasnt clear earlier)
I have a table below above is the table i have below is what i want using alteryx can anyone help?
You are looking for the Summarize tool using Group By on [id]
Click the Open Example link in the tool summary to see examples of how to use the tool.
@michael_treadwell has pointed you to the correct tool. Not sure I understand what is conditional about the process.
Looks like you are just summing the two count columns and grouping by everything else but the PID column?
If you want to peek at a working model to help you further, the answer is in my attachment.
Its not simple summarize as i am adding sum columns for every product
for ex sum_f is for all the rows matching product f and so on..so grouping by id will give me overall sum not the product wise summation
cannot open your workflow apparently its on the newest version
You should be able to open this yxmd workflow.
The file worked but that is not the solution i am looking for. The idea is to get column for every product and sum it. Check the updated output above.