Getting table not found error

[ckchouk123]

I am doing a simple load of data from one table to another as follow:

Table2:

Load

Field1,

Field2,

Field1 & '/' & Field2 as Field3

Resident Table1;

Table3:

Load Distinct *

Resident Table2;

When I reference my script later in the code, I get an error saying that Table3 can not be found.

[ckchouk123]

When I reference Table 3 later in the code, I get an error saying that Table3 can not be found.

[luismadriz]

Hi,

As the fields in Table3 are exactly the same as in Table2 Qlik would concatenate into Table2

Use NoConcatenate

I hope this helps,

Cheers,

Luis

[luismadriz]

Table3:

NoConcatenate

Load Distinct *

Resident Table2;