Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Dear Community,
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:
--
Year
Month
Cost Center
Value
--
The corresponding Load-Script looks basically like this:
--
directory
load
Year,
Month,
Cost Center,
Value
from ...
--
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
Year
Month
Cost Center
Value
Datatype is a constant value: "IST"
Thanks in advance and kind regards,
donuteater
Hi,
mWoolf's script is very easy to implement. Please refer to the attached file for a working example of the same.
Hope that helps.
Regards,
-Shahbaaz.
Use a preceeding load.
Add this just above the Excel load:
load
*,
'IST' as Datatype;
Where exactly?
Directory;
crosstable(Month, Wert, 2)
LOAD DEPARTMENT,
MONTH as KPI,
[1] as Jan,
[2] as Feb,
[3] as Mar,
[4] as Apr,
[5] as May,
[6] as Jun,
[7] as Jul,
[8] as Aug,
[9] as Sep,
[10] as Oct,
[11] as Nov,
[12] as Dec
FROM [Test.xls] (biff, embedded labels, table is Sheet1$);
Try it just above the crosstable function
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.
Try this AFTER your load:
load
*,
'IST' as Datatype
resident YourExcelTableName;
I'm sorry, but i don't understand the syntax and where it should be inserted. Sorry, i'm a total beginner.
Hi,
mWoolf's script is very easy to implement. Please refer to the attached file for a working example of the same.
Hope that helps.
Regards,
-Shahbaaz.
Thank you so much!
I finally got it. 🙂
How you could add column?