Identify and delete duplicates

[caffe2004]

Hi,

I have below table.

I'd like to find any two rows with the same customer and car#, but volume net to zero and delete them, like row 3 and 4 above. How can I achieve it in Alteryx? Any help is appreciated.

[trsali · Accepted solution]

Hi @caffe2004 here is a way to accomplish your ask.

Using the summarize tool to group by customer and car# and sum of volume. Filter out the values were the volumes are = 0, join the results back to the original set to get all the individual customers and car#.

Please mark this as the solution if it helped

[caffe2004 · Accepted solution]

This works great. Really appreciate your help:)