Bring your best ideas to the AI Use Case Contest! Enter to win 40 hours of expert engineering support and bring your vision to life using the powerful combination of Alteryx + AI. Learn more now, or go straight to the submission form.
Start Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

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

ToxicBuoy
7 - Meteor

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:

IDDateValue
111-06-201
212-06-201
323-07-201
113-06-201
211-08-201
111-06-200
212-06-200
3 REPLIES 3
Assaf_m
11 - Bolide

Check the attached workflow.

 

let me know if it works for you

grazitti_sapna
17 - Castor

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.

Sapna Gupta
ToxicBuoy
7 - Meteor

Thanks that worked

Labels
Top Solution Authors