Help

Save the date! Join us on October 16 for our Product Ops launch event. Register here.

Uniclass Sorting

Topic Labels: ImportingExporting
1050 1
cancel
Showing results for 
Search instead for 
Did you mean: 
AB1-Airtable
4 - Data Explorer
4 - Data Explorer

Hello!

Newish to Airtable, sorry.

I am trying to sort a table that consists of all of the ISO 19650 Uniclass codes, links below:

https://buildig.com/uniclass-2015/uniclass2015/Uniclass2015.csv

The top level includes 12 tables.

Each of these breaks down into Groups, Sub-groups, Sections, and Objects.

The tables have no entry for Groups, Sub-groups, Sections, and Objects.

The Groups have no entry for Sub-groups, Sections, and Objects.

Etc.

In the dataset there are multiple items with the same Group number for different tables, etc.

I would like to reorganize it so that so that each Group has a unique identifier, possibly the titie.

Would this best be achieved with a junction table?

1 Reply 1
AB1-Airtable
4 - Data Explorer
4 - Data Explorer

So I did it manually but it was pretty easy.

Filter out tables, copy, paste into new table

Filter out Groups, copy, paste into new table and link to Tables

Filter out Sub-groups, copy, paste into new table and link to Groups

Then link all Objects to Sub Groups and lookup rest of fields