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)
[Unique Carrier Code],
[Carrier Group ID (Old)],
[Carrier Group ID],
FROM [Employment Statistics - CrossTable.qvd] (qvd);