Upcoming database upgrades. Airtable functionality will be reduced for ~15 minutes at 06:00 UTC on Feb. 4 / 10:00 pm PT on Feb. 3. Learn more here

How do I create a synced "join lookup" table?

180 0
Showing results for 
Search instead for 
Did you mean: 

I am looking for a way to convert a table (ideally, automatable on field update) in this format:

Project ID Impacted Team(s)
101 1, 2, 3
102 2
103 1, 3

to this format:

Project ID Impacted Team
101 1
101 2
101 3
102 2
103 1
103 3

so that I can filter on multi-select fields (comma delimited values) in BI tools such as Tableau. I’ve seen this format referred to as a “join lookup” table in a previously used application.

Tableau Desktop alone cannot do this via split & pivot as pivoting on calculated fields (split) is not supported. Tableau Prep, which can do this, does not support WDC connected data sources, such as Airtable requires.

Any suggestions?

0 Replies 0