Create a 'daughter table' with lookup columns

[schwibach]

Hello,

I have a PostgreSQL database with over 300 highly normalised tables, which I have no control over.

My goal is to create one denormalised, readable table that we can use to create dashboards.

So, I would like to create a new table, take the ID column (and a few others, not all!) from one other table and then do lookups from other tables. I can to the lookups, but I don't know how to create a new table with ID column.

Thank you guys!

[schwibach]

Thank you very much! That did the trick for me! 🙂

[amitchandak · Accepted solution]

@schwibach ,

You can create like

ID Table = distinct(union(distinct(Table1[ID]), distinct(Table2[ID]) , distinct(Table2[ID]) ) )

Add other tables if needed