Kindly help me out:
I want to create a logic where for each row, output(Value) will be 1 if (combination of ID and Date) has not occurred before, if occurred then 0. Sample below:
ID | Date | Value |
1 | 11-06-20 | 1 |
2 | 12-06-20 | 1 |
3 | 23-07-20 | 1 |
1 | 13-06-20 | 1 |
2 | 11-08-20 | 1 |
1 | 11-06-20 | 0 |
2 | 12-06-20 | 0 |
Solved! Go to Solution.
HI @ToxicBuoy , you can use unique tool by configuring and place formula tool where you can put 1 for unique records and 0 for duplicate records then union them you will get the result as expected.
Thanks.
Thanks that worked