Databases Reference
In-Depth Information
9.
Create a new compound key on both of the tables by using the following
script expression:
Period
& ' | ' & [%Airline ID]
& ' | ' & [%Unique Carrier Code]
& ' | ' & [%Carrier Group ID] as [%Key Field],
10. Add a new tab from the
Tab
menu and name it
Link Table
. Make sure this
new tab is located to the right-side of both the
Employment Data
and
Main
Data
tabs.
11. In the
Link Table
tab, add the following script:
[Link Table]:
Load Distinct
[%Key Field],
[%Key Field] as [%TEMP Key Field],
Year,
Period,
[Month (#)],
Month,
Quarter,
[%Airline ID],
[%Unique Carrier Code],
[%Carrier Group ID],
[Unique Carrier],
[Carrier Code],
[Carrier Name]
Resident [Main Data];
Concatenate ([Link Table])
Load Distinct
[%Key Field],
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]
Resident [Employment Statistics]
Where Not Exists([%TEMP Key Field], [%Key Field]);