Issue in Cross table

[QlikNoviceNo1]

Hi all , I am trying to transform some data which is in a cross table format. Kinda new to cross tables hence the query.

The script that gets generated in the transformation step looks like below: I gave 9 as Qualifier fields parameter, Attribute field as Month and Data Field as No Of Employees. However, I am getting orphan columns in the data model pertaining to each month number.

CrossTable(Month, [No Of Employees], 9)

LOAD %Key,

     Year,

     [Airline ID],

     [Unique Carrier Code],

     [Unique Carrier],

     [Carrier Code],

     [Carrier Name],

     [Carrier Group ID (Old)],

     [Carrier Group ID],

     [01],

     [02],

     [03],

     [04],

     [05],

     [06],

     [07],

     [08],

     [09],

     [10],

     [11],

     [12]

FROM [Employment Statistics - CrossTable.qvd] (qvd);

[qlikviewwizard]

To eliminate Orphan tables in Crosstab Load, we need to use Where 1=1 condition.

You can see the output like the below.

[QlikNoviceNo1]

wow! That did work.. Thanks..!

What is the logical explanation that these orphan tables got created? and how did the condition 1=1 eliminate them? It's kinda puzzling

[qlikviewwizard]

It is trick.