The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.

Pull unique values and no of occurances for particular column into seperate columns

posted Aug 26, 2021 3:52:28 AM

Topic Labels: API

Solved

Jump to Solution

0 1522 1

We have a requirement like below.
e.g.
Consider a table with column as Names.
Names
abc
xyz
abc
pqr
pqr

We want two columns in another table as below.
UniqueNames NamesCount
abc 2
xyz 1
pqr 2

Is there any way to achieve this?

1 Solution

Accepted Solutions

Solved

Hi,
Yes, that’s also a nice demo of link creating logic in airtables (link to existing record, and if not, create and link):

create new empty table2
in table1, add linked field to table2
copy-paste Names (whole column) to linked field
in table2, add count field to linked
that’s all
to perform cleanup, you could also:
(table2) convert count to text, delete records where linked field is empty,
(both) remove linked fields

See Solution in Thread

1 Reply 1

Solved

Hi,
Yes, that’s also a nice demo of link creating logic in airtables (link to existing record, and if not, create and link):

create new empty table2
in table1, add linked field to table2
copy-paste Names (whole column) to linked field
in table2, add count field to linked
that’s all
to perform cleanup, you could also:
(table2) convert count to text, delete records where linked field is empty,
(both) remove linked fields