Forum Discussion

gheisargheisar's avatar
gheisargheisar
Frequent Visitor
6 years ago
Solved

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

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 betw...
Need Help
  • v-xicai's avatar
    v-xicai
    6 years ago

    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.

     

v-xicai's avatar
v-xicai
Community Support
6 years ago

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.