Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Adding an additional column via Script

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

11 Replies
Not applicable
Author

tx @ mwoolf

Amarnath
Partner - Contributor
Partner - Contributor

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.