How to find out duplicate value on the row and delete it. Need help!

[Joco_Wijaya]

Hi Guys,

is there any way to find duplicate value on our table and delete them?

I found some suggestion to follow this formula
Table.Filter(Column.Contains(Column)).Count()>1

Howerver, it does not work for me.

Need help! I am new with coda!

[Jean_Pierre_Traets]

Dear @Joco_Wijaya

Hopeful this post will be usefule to find your duplicates

[Saul_Garcia]

Hello Joco! In that formula you have to replace Table with the name of your table and Column with the name of the column you are trying to check if its duplicated. Hope this helps, in any case, It is always better to ask a question posting an example file or maybe screenshots so it is easier to help.

[Paul_Danyliuk]

Hey Joco,

Take a look at my solution here. It marks rows with data that already appeared before as duplicates:

Calculate values based on unique dates

Chiming in. First of all, I think the fact that you can have multiple entries with the same date and number of rooms is the problem itself. And the best way to approach your need would be to get rid of duplicates in the table in the first place. But let’s assume that for some reason it’s not possible. Logically I’d approach the problem in the same spirit: Determine if a row is a duplicate of already present row — I’d make a separate column for that Then calculate only rows that aren’t duplic…

In that case each row has an ID, so to only search for duplicates in previous rows, I can filter those down to id < thisRow.id. If your table doesn’t have an ID system, you can create a Row ID column (e.g. by clicking the blue “add column” button → Properties → Row ID) and use that.

[Joco_Wijaya]

Thank guys. I got the solution. Amazing =)