Identifying duplicates in values

F600314

Hi All,

I have following data set

Security	Duplicates
A	FALSE
A	TRUE
B	FALSE
B	TRUE
C	FALSE
C	TRUE
D	FALSE
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 

rkapoor

@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.

F600314_sample.yxmd