logic, if a value has appeared before in the same row

[ToxicBuoy]

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

[Assaf_m · Accepted solution]

Check the attached workflow.

let me know if it works for you

[grazitti_sapna]

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.

[ToxicBuoy]

Thanks that worked