Forum Discussion
Duplicate to null and date to integer
Hey Guys, I have the issue, that my data involves dates, some with duplicates, some without. Now what I need/want to do, is: 1. instead of deleting the duplicates make them to null values. 2. ...
Hi Nick2,
You could achieve this in Query Editor by the steps below.
1. Go to Query Editor and select the Date column and click Group By like below.
2. Then select Date and Count, click Unpivot Columns and you will get the values below;
3. Replace the value 2 to null and remove other columns.
4.Filer the values without 1.
5. Change Date type to Whole number.
For reference, you could have a look at my test file which has been attached below.
Best Regards,
Cherry