Script Execution Error

[#1]

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.

[ecolomer]

You can put a name different for each file.

MONTH_1:

LOAD ......

MONTH_2:

LOAD ....

[#3]

[its_anandrjs]

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

[#5]

Yes I did it ,but no use.

[#6]

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

Thanks

[ecolomer]

if the names of data are equal you need QUALIFY identificator

QUALIFY *;

MONTH_1:

LOAD ...

MONTH_2:

LOAD ....

[#8]

@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;

[ecolomer · Accepted solution]

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