topic Re: Script loading failed in QlikView

Script loading failed

Mon, 11 Apr 2016 05:53:17 GMT

Hi All,

I have script like below

LOAD *,

if(Field='A',1,0) as Flag

FROM Table A;

LOAD *,

if(Field='A',1,0) as Flag

FROM Table B;

LOAD *

Resident A

where Flag=1;

Concatenate

LOAD *

Resident B

where Flag=0;

drop tables A , B;

But it's giving table not found error.

Re: Script loading failed

Kushal_Chawda — Mon, 11 Apr 2016 05:55:12 GMT

I think you are facing the autoconcatenate issue. try like below

LOAD *,

if(Field='A',1,0) as Flag

FROM Table A;

Noconcatenate

LOAD *,

if(Field='A',1,0) as Flag

FROM Table B;

Noconcatenate

LOAD *

Resident A

where Flag=1;

Concatenate

LOAD *

Resident B

where Flag=0;

drop tables A , B;

Re: Script loading failed

Mon, 11 Apr 2016 05:57:55 GMT

Is fields are same in both the tables then use noconcatenate

Re: Script loading failed

kkkumar82 — Mon, 11 Apr 2016 06:08:02 GMT

Is there space between the names of the tables then they should be in [ ]. once check out.

Can you show the error you are getting as an image or attached qvw with the data sources you are using.

Re: Script loading failed

Chanty4u — Mon, 11 Apr 2016 06:11:12 GMT

try to No concatenate the tables.

Re: Script loading failed

Mon, 11 Apr 2016 08:42:22 GMT

Hi qvlearn123

U can use a where statement in the load to only load the rows you want

Load

FROM

Table A

Where

Field = 'A';

Load

FROM

Table B

Where

Field <> 'A';

Table B will then concatenate into Table A