We have extended our Early Bird Tickets for Inspire 2023! Discounted pricing goes until February 24th. Save your spot!

Alteryx Designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer 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