Adding an additional column via Script

[#1]

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

[#2]

tx @ mwoolf

[Amarnath]

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.