Databases Reference
In-Depth Information
[Carrier Name],
[%Carrier Group ID],
[# Full Time Employees],
[# Part Time Employees],
[# Equivalent FTEs]
Resident Temp_Employment
Order By [%Airline ID], Year, [Month (#)];
We are almost ready to reload our script and see the result. We just need to add a
Drop
statement to remove the
Temp_Employment
table from RAM after using it in the
Resident load
script. Add the following code at the end of the
Transformation
tab:
Drop Table Temp_Employment;
After this, save the changes we've made to the QlikView document and hit
Reload
(or press
Ctrl
+
R
). The script will perform the transformation and, after it's finished,
we can open the
Table Viewer
window and preview the resulting
Employment
table. Here is what we'll see:
From the
Preview
dialog window, we can see how the very first airline (
19386
) has
had an erratic behavior in their headcount. In February 2009, they had a bump of
54
employees, and in the following month their headcount dropped by the same
amount. Then, a massive reduction of
3568
took place in May 2009.
Now that we've added the # Delta Total Employees field, let's add the corresponding
delta fields for part-time and full-time employees, as well as FTEs. We will also add
the
store
command to save the output table to a QVD file.