Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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);
To eliminate Orphan tables in Crosstab Load, we need to use Where 1=1 condition.
You can see the output like the below.
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
It is trick.