Remove Duplicate Rows Completely

[khadijahneddy]

Hi, greetings everyone!

Can someone help me on how to remove the duplicate rows (RecordID, Data and File) completely? Tried to use the unique tools but it didn't work out.

Thank you in advance for the help!

[atcodedog05]

Hi @khadijahneddy 

Unique tool should have worked. Provided (RecordID, Data and File) are unique. Hope you have set the columns in unique tool

Can you provide the data as excel so that we can take a look.

[Qiu]

@khadijahneddy 
so you mean if any duplicated, remove them all?

[vizAlter · Accepted solution]

Hi @khadijahneddy —  "Unique" tool is made for your purpose and it considers the case sensitivity.

Hence, your fields do not have any Upper or Lower case in text kind of issue.

(And, to convert your text in Upper or Lower case you may use a "Data Cleansing" tool, then apply a "Unique" tool.)

If this assists please mark the answer "Solved", if not let me know!

[grazitti_sapna]

Hi @khadijahneddy,

Unique tool should have worked for your use case. If you are facing issues can you please share a sample dataset?