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
tx @ mwoolf
Table1:
LOAD
"Dlr Code",
Model,
TargetDate,
Enquiry_Target,
Booking_Target,
Retail_Target,
Test_Drive_Target,
Whole_Sale_Target
FROM [lib://Assignment/Sales_Target_Nov_16.xlsx]
(ooxml, embedded labels, table is [sheet 1]);
Table2:
Load *,
TgtM as Target_Month
Resident Table1;
Drop Table Table1;
I tried using your code but i got an error. Please look into this.