Forum Discussion

Rolf's avatar
Rolf
Frequent Visitor
8 years ago
Solved

Remove duplicates based on values from multiple cells

Hey,   I am trying to append few datasets. The problem with my data is that there may be completely identical rows in there which i want to remove. At the end i only want to keep the truly unique r...
  • v-jiascu-msft's avatar
    v-jiascu-msft
    8 years ago

    Rolf,

     

    Hi Rolf.

     

    It's easy to do it in the Query Editor.

    1. Select the columns "ID", "lat", "longit", "Time" at the same time with "Ctrl".

    2. Use the function as Anonymous suggested.

     

     

     

     

     

     

     

     

     

     

     

     

     

     

    Best Regards!

    Dale

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Thanks a lot for the tip. It works well and I'm now able to have my data closer to the real values. But I'm still struggling to succeed on consolidating one of my tables. 

 

Same production order with feedback on different dates

I want to consolidate by production order and keep the last feedback date. I have tried group by in different ways, but I'm missing values, therefore the report is not accurate. 

Any idea/suggestion on how to do it?

Enrique