Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Make your voice heard! Participate in the 2020 Wisdom of Crowds® Survey. BEGIN SURVEY
Highlighted
Not applicable

Re: Adding an additional column via Script

tx @ mwoolf

Partner
Partner

Re: Adding an additional column via Script

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.