topic Re: Adding an additional column via Script in QlikView

Adding an additional column via Script

Tue, 21 Feb 2012 17:54:00 GMT

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:

Adding an additional column via Script

m_woolf — Tue, 21 Feb 2012 17:57:22 GMT

Use a preceeding load.

Add this just above the Excel load:

load

'IST' as Datatype;

Re: Adding an additional column via Script

Tue, 21 Feb 2012 18:07:49 GMT

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$);

Re: Adding an additional column via Script

m_woolf — Tue, 21 Feb 2012 18:14:27 GMT

Try it just above the crosstable function

Re: Adding an additional column via Script

Tue, 21 Feb 2012 18:31:18 GMT

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.

Re: Adding an additional column via Script

m_woolf — Tue, 21 Feb 2012 18:34:19 GMT

Try this AFTER your load:

load

'IST' as Datatype

resident YourExcelTableName;

Adding an additional column via Script

Wed, 22 Feb 2012 07:42:23 GMT

I'm sorry, but i don't understand the syntax and where it should be inserted. Sorry, i'm a total beginner.

Re: Adding an additional column via Script

Wed, 22 Feb 2012 09:07:54 GMT

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.

Adding an additional column via Script

Wed, 22 Feb 2012 09:52:34 GMT

Thank you so much!

I finally got it. 🙂

Re: Adding an additional column via Script

farolito20 — Mon, 17 Dec 2012 14:43:46 GMT

How you could add column?

Re: Adding an additional column via Script

Tue, 07 May 2013 12:53:06 GMT

tx @ mwoolf

Re: Adding an additional column via Script

Amarnath — Mon, 29 Jul 2019 15:44:22 GMT

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.