again i am confronted with a problem i'm not able to solve.
I'm exporting a number of figures from a Excel-File with the following columns:
The corresponding Load-Script looks basically like this:
My question is, how can i add one more column to the load, which has always the same value?
The "artificial" Table should look like this:
Datatype is a constant value: "IST"
Thanks in advance and kind regards,
crosstable(Month, Wert, 2)
MONTH as KPI,
 as Jan,
 as Feb,
 as Mar,
 as Apr,
 as May,
 as Jun,
 as Jul,
 as Aug,
 as Sep,
 as Oct,
 as Nov,
 as Dec
FROM [Test.xls] (biff, embedded labels, table is Sheet1$);
I'm sorry, but then the crosstable function doesn't seem to work properly. After the execution of the script i can only select every month individually by it's name and not via the Month-Dimension.
Furthermore all the KPIs are gone.