We are celebrating the 10-year anniversary of the Alteryx Community! Learn more and join in on the fun here.
Start Free Trial

Alteryx Designer Desktop Discussions

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

Identifying duplicates in values

F600314
6 - Meteoroid

Hi All,

 

I have following data set

SecurityDuplicates
AFALSE
ATRUE
BFALSE
BTRUE
CFALSE
CTRUE
DFALSE
F

FALSE

 

I want to create duplicate column True/False as above. In excel we can input A2=A1  and get the same 

What tool in Alteryx 

1 REPLY 1
rkapoor
Alteryx
Alteryx

@F600314 you can use the Multi-Row Formula Tool to achieve this as attached.

 

Also, I recommend you explore the Unique Tool for identifying duplicate data.

Labels
Top Solution Authors