Databases Reference
In-Depth Information
9.
Add the
Concatenate
prefix to the load statement, specifying that the
Main
Data
table is the one to which this will be appended. The added script should
look as follows:
Concatenate ([Main Data])
LOAD Year,
Period,
[Month (#)],
Month,
'Q' & Ceil(Month/3, 1) as Quarter,
[%Airline ID],
[%Unique Carrier Code],
[%Carrier Group ID],
[Unique Carrier],
[Carrier Code],
[Carrier Name],
[# Full Time Employees],
[# Part Time Employees],
[# Total Employees],
[# Equivalent FTEs]
FROM
[..\Data Files\QVDs\T_F41SCHEDULE_P1A_EMP.qvd]
(qvd);
It is of fundamental importance that this script be added in a tab that is to
the right of the
Main Data
tab, as we are referencing the
Main Data
table
and. For that to work, the table must have been loaded previously, during
the script execution. Remember that script executes sequentially from left
to right.
10. Save the changes and reload the script.
As no actual tables have been added to the data model, the resulting model will look
identical to the one we had before adding the script. The only difference will be the
new fields that are included at the end of the
Main Data
table that correspond to the
employment measures. Use the
Table Viewer
dialog to verify that the new fields
have been added.
We have described the first approach for dealing with multiple fact tables in a data
model. In the next section, we will present yet another option along with its pros
and cons, so that you, as a Developer, can better decide which one will suit your
needs best.
To continue, save and close the
Chapter 8_Concatenated tables.qvw
document.
