+2I've only been using Airtable for a short time, and coming from RDBMS, I admit I'm struggling a bit.
Right now, I'd just like to get the equivalent of a “select distinct ... from...” and I can't seem to do it.
I have a table with a column called category.
How can I create a view containing one row per distinct category?
I want to use it in n8n...
Thank you for your help.
+31Try converting the ‘Category’ field into a linked field to a new table:
If you need it to be a multiple select, then you could try using an automation to paste the values from the multiple select into a linked field every time the multiple select gets updated
+28Hey
As mentioned by Adam, you’ll want to have a new completely new table to such effect. In it you’ll have the list of all possible options -and you’ll link these two tables via linked record field. Just FYI, remember that in Airtable one table can have one or multiple views (more on Airtable views here). So what you want in this case is a table rather than a view!
Mike, Consultant @ Automatic Nation
+2Hello
Since the table is fed by batch, I couldn't use the proposed solution.
I approached the problem from the other direction:
I created a “category” table and an Airtable automation script that runs several times a day. It checks the “prospect” table to see if there is a new category and adds it to the category table if necessary.
Thank you for your help.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.