Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

etrotter
Contributor II

Table Not Found

Hi,

I am doing a resident load, but for some reason it's not recognizing the "Workday" table it just keeps saying table not found. There is  a table called Personal earlier in the script that I'm resident loading from. Please let me know if you can help:

Workday:

Load DISTINCT

[Encore.W_CODE],

Worker_ID,

[GLS.W_CODE],

Address,

City,

State,

Zip_Code,

First_Name,

Last_Name

Resident Personal;


Drop Table Personal;


Left Join (Workday)

Load

Worker_ID,

Shift_Pay

Resident Compensation;

1 Solution

Accepted Solutions
MVP
MVP

Re: Table Not Found

If you load a table from a resident table and you keep all the fields the same  it will not create a new table but rather add all the records to the first table.

You can avoid that by using a NOCONCATE prefix like this:

Workday:

Noconcatenate LOAD DISTINCT

....

;

1 Reply
MVP
MVP

Re: Table Not Found

If you load a table from a resident table and you keep all the fields the same  it will not create a new table but rather add all the records to the first table.

You can avoid that by using a NOCONCATE prefix like this:

Workday:

Noconcatenate LOAD DISTINCT

....

;

Community Browser