topic Re: Script Execution Error in QlikView

Script Execution Error

Sun, 28 Dec 2014 17:12:39 GMT

Hi all ,

Whenever I tried to use No concatenation or Left keep in between those two files script execution stops there it wont come out,I need to close qlikview application every time. FYI those two tables got same number of fields with same names. Each table got one month data.

I need your help experts.

Thanks.

Re: Script Execution Error

ecolomer — Sun, 28 Dec 2014 17:16:32 GMT

You can put a name different for each file.

MONTH_1:

LOAD ......

MONTH_2:

LOAD ....

Re: Script Execution Error

Sun, 28 Dec 2014 17:16:42 GMT

Re: Script Execution Error

its_anandrjs — Sun, 28 Dec 2014 17:17:42 GMT

Can you provide the exact script where you have problems i believe use ony one of them at a time weather it is Noconcatenate or Left Join use one of them better you use Left join.

Provide the script or data file.

Regards

Anand

Re: Script Execution Error

Sun, 28 Dec 2014 17:18:18 GMT

Yes I did it ,but no use.

Re: Script Execution Error

Sun, 28 Dec 2014 17:20:05 GMT

FYI As you can see on attachment, i got two tables Billing_Dec13,Billing_Feb14.

Thanks

Re: Script Execution Error

ecolomer — Sun, 28 Dec 2014 17:20:12 GMT

if the names of data are equal you need QUALIFY identificator

QUALIFY *;

MONTH_1:

LOAD ...

MONTH_2:

LOAD ....

Re: Script Execution Error

Sun, 28 Dec 2014 17:25:52 GMT

@Anand Chouhan

Billing_Dec13:

First 20000 LOAD BILL_MONTH,

ZONE,

BU,

CONNECTION_NO,

PREV_SERVNO,

DIVISION,

SUB_DIVISION

FROM

(ooxml, embedded labels, table is [Billing & Collection Data]);

store Billing_Dec13 into $(vPath) Billing1_Dec13.qvd;

Billing_Feb14:

NoConcatenate

First 20000 LOAD BILL_MONTH,

ZONE,

BU,

CONNECTION_NO,

PREV_SERVNO,

DIVISION,

SUB_DIVISION

FROM

(ooxml, embedded labels, table is [Billing & Collection Data]);

store Billing_Feb14 into $(vPath) Billing1_Feb14.qvd;

Re: Script Execution Error

ecolomer — Sun, 28 Dec 2014 17:39:05 GMT

as the names of the fields are equal must use the qualifier QUALIFY