Qlik Community

Ask a Question

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Talk to Experts Tuesday, January 26th at 10AM EST: Qlik Sense. REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Script Execution Error

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.

1 Solution

Accepted Solutions
Master II
Master II

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

View solution in original post

8 Replies
Master II
Master II

You can put a name different for each file.

MONTH_1:

LOAD ......

MONTH_2:

LOAD ....

Not applicable

Screenshot (6).png

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

Not applicable

Yes I did it ,but no use.

Not applicable

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

Thanks

Master II
Master II

if the names of data are equal you need QUALIFY identificator

QUALIFY *;

MONTH_1:

LOAD ...

MONTH_2:

LOAD ....

Not applicable

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

Master II
Master II

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

View solution in original post