Forum Discussion

walker21's avatar
walker21
Frequent Visitor
3 years ago
Solved

Remove Duplicates

Hello, I have a column called "name" and this column duplicates depending on what city they go to. I need to be able to delete the first row of the duplicates and keep the latest actions. I tried th...
Need Help
  • Ashish_Mathur's avatar
    Ashish_Mathur
    3 years ago

    Hi,

    In the Query Editor, ensure that the column is formatted as Date/Time (since the entries in that column are lft aligned, it seems that the data type of the column is text).  Thereafter write this calculated column formula

    Test = 1*(Data[created on]=calculate(min(Data[Created on])),filter(Data,Data[Created on]=earlier(Data[Created on])&&data[week number]=earlier(data[week number]))))

    Hope this helps.

Ashish_Mathur's avatar
Ashish_Mathur
Super User
3 years ago

Hi,

In the Query Editor, ensure that the column is formatted as Date/Time (since the entries in that column are lft aligned, it seems that the data type of the column is text).  Thereafter write this calculated column formula

Test = 1*(Data[created on]=calculate(min(Data[Created on])),filter(Data,Data[Created on]=earlier(Data[Created on])&&data[week number]=earlier(data[week number]))))

Hope this helps.