Help

Like SQL | Select distinct after group by

Topic Labels: Base design
582 1
cancel
Showing results for 
Search instead for 
Did you mean: 
Gabriel_h
4 - Data Explorer
4 - Data Explorer

Hello all, 

I'm getting to know Airtable and might have this newbee question: I'm trying to select the distinct entries of a table after a group by, something like in SQL would be done by

SELECT DISTINCT Actors
FROM MovieDetails
GROUP BY Actors

I'm finding some difficulties in doing this easily in Airtable: is this easily done?

Many thanks in advance for your help and best wishes,
G.

1 Reply 1

Hi,

indeed, I don't understand the purpose of group by after select distinct with the same field.

if you need the set of unique Actors in the column, there are many way to do it. I think faster way is (don't works with primary field, you need to duplicate it) - click 'edit field', choose single select without clicking 'Save', under 'colored options' you have a list of distinct values with scroll bar, you can copy this list to clipboard, and press 'Cancel' instead of 'Save'. 

Then use list in clipboard according to your needs.