Let’s talk Alteryx Copilot. Join the live AMA event to connect with the Alteryx team, ask questions, and hear how others are exploring what Copilot can do. Have Copilot questions? Ask 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