Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

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
RishiK
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