Add function to remove duplicates to formular

1

Hi community,

i have this formula. Its combining all cells of a column. How do i need to modify it, so it does remove all duplicates as well?

Concatenate(FormulaMap(Connector.ContactTags, CurrentValue.ToText() + "; "), “”)

image
image1686×1734 457 KB

Thx alot.

2

Hey there :slight_smile:
Probably just add .Unique() to Connector.ContactTags

1 Like
3

Thx Rick. I still cant’ make it to work- i am very new with coda. Can you write the whole formula?

4

Oh alright, welcome to Coda!

I was thinking like this :slight_smile:

Concatenate(FormulaMap(Connector.ContactTags.Unique(), CurrentValue.ToText() + "; "), "")

You can also probably make the formula cleaner, like this

Connector.ContactTags.Unique().Join("; ")
1 Like
5

@Rickard_Abraham It’s strange. Everything what ChatGPT gave me and both of your formulas don’t create a error, but the word count stays always the same…

6

Solution:

unique(split(Concatenate(FormulaMap(Connector.[Your Column], CurrentValue.ToText() + “; “), “”),”;”))

7

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.