Help

Re: Pulling data from 2 tables into a single export

789 0
cancel
Showing results for 
Search instead for 
Did you mean: 
Rosy_Carter
4 - Data Explorer
4 - Data Explorer

I have 2 tables:

  • Organisations - which contains fields related to organisations we have funded to run projects - each record includes the organisation’s postcode
  • Projects - which contains fields related to projects run by these organisations.

The 2 tables are linked -a project links to one org and an org can link to multiple projects.

I want to export the project table to csv to create a map of the projects but I need the postcode to be exported too and it’s in the other table. Can I do this? I currently only get the organisation’s name in the csv file as it’s the primary field of the org table. Thanks!

2 Replies 2

Hi @Rosy_Carter and welcome to the community!

Did you try using lookup fields?

Rosy_Carter
4 - Data Explorer
4 - Data Explorer

Hi thanks for your reply. I have added the Postcode field using the lookup field type and it works perfectly!