Help

Welcome to the Airtable Community! If you're new here, check out our Getting Started area to get the most out of your community experience.

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

Topic Labels: API
Solved
Jump to Solution
461 1
cancel
Showing results for 
Search instead for 
Did you mean: 

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

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

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