How can i filter row that have the same content in a table?

1

Hello everyone, i would like to know if, with filter, is possibile to filter row that have the same content, so that appear only one row
For exemple in my table i would like that if the content in the column “Tipologia e Fase” is the same, appear only one row and not 2 row like in the photo

Coda
Coda1160×670 75.5 KB

Thanks a lot for your response

2

Hi Alessio,

Could you provide a copy of the document, and some more information?

Are you filtering on the “tipologia e fase” column? If so, which of the entries should be presented?

It could be as simple as adding .first() to a filter in Tipologia…

Regards
Piet

3

Thanks for the response

Here a copy of the document https://coda.io/d/Coda-community_ddaj2457igX/Coda-community_suJEY#_luCrS

I would like that in the column “Tipologia e Fase”, with a use of a filter in the table, don’t appear the duplicate value. So, for example, the “Definizione OKR nella fase di onboarding” appear one time and not 3.

I hope it’s clear and thanks for your response
I

4

Good morning,

I have completed your doc. If I have understood correctly :slight_smile:

5

Hi Math, thanks for your response.
I’m seeing but is not the same that i need.

What I mean if is possibile with filter, to hide duplicate values of the column “tipologia e fase”, so the final result (with the filter that we need to inser) will be this table https://coda.io/d/_ddaj2457igX/Coda-community_suJEY#_lu2OL

Thanks

6

In the example I’ve set 2 to display.
But you can easily set just one in the filter.

Then why report and not the other 2?

If you absolutely want to report if More one item, you’ll have to use a different method/organization or add specific filter.

image
image902×327 19.9 KB

7

Try this filter formula :slight_smile:

thisTable.Filter(thisRow.Tipologia e fase=CurrentValue.Tipologia e fase).First() = thisRow

Original
image

Filtered
image

8

Thank @Math_24 and @Rickard_Abraham for your help.

You tell me the solution and now it works

Thanks a lot and have a nice day!