Help

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

Topic Labels: API
Solved
Jump to Solution
1122 1
cancel
Showing results for 
Search instead for 
Did you mean: 
Shashank_Ambeka
4 - Data Explorer
4 - Data Explorer

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
Alexey_Gusev
12 - Earth
12 - Earth

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
Alexey_Gusev
12 - Earth
12 - Earth

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