Hi All,
What is the best method to feed data one central table with data from multiple other tables?
Here is the scenerio/requirement:
>BI Query 1 --> VC Table 1 --|
>.........................................|
>BI Query 2 --> VC Table 2 --|
>.........................................>----> Master Table to display on VC dashboard
>BI Query 3 --> VC Table 3 --|
>.........................................|
>BI Query 4 --> VC Table 4 --|
Viewing data in the individual tables is straight forward enough, but what are the recommended methods of showing data from Tables 1, 2, 3 and 4 (which contain the same fields/structure) in a final 'master' table?
Possible approaches:
1] Referencing cells in Tables1-4 from within the master table;
2] Feeding/sending values to the master table from Tables1-4;
The reason for not simply grouping 4 initial tables together (i.e. one below another) in the first place is due to each table displaying column headers, which not only takes up unnecessary space, but also surplus to requirements, considering the structure of Tables1-4 are the same (e.g. Table 1 = sales figures for company ABC, Table 2 = sales figs for Company XYZ).
Alternative suggestions are welcomed, as are methods on achieving the two possible approaches above.
Many Thanks,
Chet.