Solved: Pull data together from 2 tables - Page 2

David_Hundt · 07-16-2021 09:21 AM

This seems like foundational stuff, but after trying to figure it out on my own all morning, I will just bask in my newbie-ness and ask for help.

I have a Schools table and a Staff table. The Schools table has all the addresses for multiple schools (School_Name, School_Address). The Staff table has all the staff that work at the different schools (Staff_Name, Position, School_Name (ref)). The tables are related with a ref to School_Name.

I would like to pull the data from the two tables together and be able to export a CSV inclusive of: Staff_Name, School_Name, School_Address. Any assistance would be most appreciated.

David_Hundt

So I’ve been messing around with this and figured out a way to get what I needed:

I added a virtual column to the Staff table and used a SELECT expression to add the address from the Schools table to the Staff table and made sure SHOW? was checked for the virtual column.
I added an Export action for the Staff table and set it to Display Overlay.
I then made a table view of the Schools table.

Now I can do other stuff like make slices or add it to a dashboard view.
If there are other ways to do this, I’d be interested to learn about them!

View solution in original post