topic Re: Getting table not found error in App Development

Getting table not found error

ckchouk123 — Thu, 28 Dec 2017 20:36:56 GMT

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 — Thu, 28 Dec 2017 20:40:28 GMT

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

luismadriz — Thu, 28 Dec 2017 22:38:56 GMT

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 — Thu, 28 Dec 2017 22:39:23 GMT

Table3:

NoConcatenate

Load Distinct *

Resident Table2;