Databases Reference
In-Depth Information
Our modified script will be:
Employment:
Load
If(
[Airline ID] = Peek('Airline ID', -1),
[# Total Employees] - Peek('# Total Employees', -1),
0
) as [# Delta Total Employees],
If(
[Airline ID] = Peek('Airline ID', -1),
[# Full Time Employees] - Peek('# Full Time Employees', -1),
0
) as [# Delta Full Time Employees],
If(
[Airline ID] = Peek('Airline ID', -1),
[# Part Time Employees] - Peek('# Part Time Employees', -1),
0
) as [# Delta Part Time Employees],
If(
[Airline ID] = Peek('Airline ID', -1),
[# Equivalent FTEs] - Peek('# Equivalent FTEs', -1),
0
) as [# Delta Equivalent FTEs],
[%Airline ID],
Year,
[Month (#)],
[# Total Employees],
Period,
Month,
[%Unique Carrier Code],
[Unique Carrier],
[Carrier Code],
[Carrier Name],
[%Carrier Group ID],
[# Full Time Employees],
[# Part Time Employees],
[# Equivalent FTEs]
Resident Temp_Employment
Order By [%Airline ID], Year, [Month (#)];
Drop Table Temp_Employment;
Store Employment into [Transformed QVDs\Employment Statistics.QVD]
(qvd);
