Script loading failed

[#1]

Hi All,

I have script like below

A:

LOAD *,

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

FROM Table A;

B:

LOAD *,

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

FROM Table B;

C:

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.

[Kushal_Chawda · Accepted solution]

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

A:

LOAD *,

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

FROM Table A;

B:

Noconcatenate

LOAD *,

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

FROM Table B;

C:

Noconcatenate

LOAD *

Resident A

where Flag=1;

Concatenate

LOAD *

Resident B

where Flag=0;

drop tables A , B;

[#3]

Is fields are same in both the tables then use noconcatenate

[kkkumar82]

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.

[Chanty4u]

try to No concatenate the tables.

[#6]

Hi qvlearn123

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

A:

Load

  *

FROM

      Table A

Where

  Field = 'A';

B:

Load

  *

FROM

      Table B

Where

  Field <> 'A';

Table B will then concatenate into Table A