Removing duplicate data with if statement based on other columns values.

[gheisargheisar]

I have a table that includes the duplicate in one column. I want to get rid of the duplicate. the criteria that witch row of duplicate I want to delete, depends on the comparison and calculation between the value of other columns. does anyone have an idea what

can I do? for example the first two-row since 14 +16 = 30, I want to delete the latest date which is the same here and the values of two last columns for a remaining row! 

 

[v-xicai · Accepted solution]

Hi @gheisargheisar ,

You may use Group by feature in Query Editor, click on the duplicate column at the same time, then go to Transform->Group By, set the Sum operation for the cumulative value column (column3).

Best Regards,

Amy

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.