The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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!
Solved! Go to Solution.
You can create like
ID Table = distinct(union(distinct(Table1[ID]), distinct(Table2[ID]) , distinct(Table2[ID]) ) )
Add other tables if needed
Thank you very much! That did the trick for me! 🙂
You can create like
ID Table = distinct(union(distinct(Table1[ID]), distinct(Table2[ID]) , distinct(Table2[ID]) ) )
Add other tables if needed