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 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! 

 

 

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.

     

1 Reply

  • v-xicai's avatar
    v-xicai
    Icon for Community Support rankCommunity 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.