Forum Discussion
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...
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
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
Thanks, must have overlooked that. Did not see that it could take multiple columns in to account.
