Forum Discussion

ivandelgra's avatar
ivandelgra
Helper I
8 years ago
Solved

How to create an input table pivoting field from multiple tables

Hello this is the situation:   I have multiple tables based on Type of school:   Then I have a table with the Max People Capacity regardless the Type of school     And at the e...
Need Help
  • jthomson's avatar
    jthomson
    8 years ago

    It'd be an awful lot easier if you merged your primary and secondary tables together...

jthomson's avatar
jthomson
Solution Sage
8 years ago

It'd be an awful lot easier if you merged your primary and secondary tables together...

  • ivandelgra's avatar
    ivandelgra
    Helper I
    8 years ago

    Thank you so much jthomson.

     

    But I do not know if in the actual situation I can do this.

    I actually have:

    - millions of records

    - 6 types of schools tables

    - the columns of the different 'type of school table' are different

    - in the primaryschool_table there is a single record for any single building, while in the others tables they are grouped by location as in the example

     

    Of course all of tables have 1 column that contains the No. of people (but with different detail aggregation depending on the table).

    Do you think that I should create a single enormous Table? (maybe working with the 'group by' feature in query editor regarding the primary school table?)