Help

Pulling from multiple tables into one table for a 'everything' category

Topic Labels: Views
988 2
cancel
Showing results for 
Search instead for 
Did you mean: 
Julie_Maden
4 - Data Explorer
4 - Data Explorer

We have multiple tables for emails, social posts, web graphics, promotions, etc. Each is assigned to a ‘communications date’ that are overlapping. We want to make a single table that pulls in the data from all these other tables for a “everything” table.

Ideas?

2 Replies 2

Not knowing much about your use-case, I would probably suggest that this data should be stored in one table - and if you need to see each type separately you should use views to do so.

Hi @Julie_Maden - generally, I would agree with @Julian_Kirkness - one table for all things identified by a “type” field and use views/filters to show things of one type. However, if your items don’t neatly fit into a single table you could consider creating an explicit “calendar” table:

Screenshot 2019-06-25 at 08.19.50.png

In your type-specific tables, rather than have a date field, link to the calendar table date:

Screenshot 2019-06-25 at 08.21.10.png

Screenshot 2019-06-25 at 08.21.15.png

JB