Cross Table -Unknow Error Issue

[amit_saini]

Hi Folks,

I'm calling a QVD (SAP Table) , it's having around 90 fields , but I'm interested on only below ones, So during transformation -First I have use Explicit option to get rid of Junk data and Second cross table:

In same table , we are having fields like WCO001....WCO016 and others , which are of no interest and hence been excluded.

Now I want to create a Month dimension using "WKG001 to WKG016" , logically :

WKG001 - Jan data

WKG002- Feb

....

....

WKG011- NOV

and last from WKG012 to WKG016 - Dec

I tried using cross table function , but it's showing "Unknown Error" message.

Please help how to categorize these "WKG..." as Month, so that I can use them as Dimm.

Thanks in advacne!

Regards,

AS

[sasiparupudi1 · Accepted solution]

Crosstable(Month,Cost,4)

[sasiparupudi1]

can you pl paste the script and the error details?