topic Re: Resident Load Error in QlikView

Resident Load Error

Wed, 25 Nov 2020 16:16:04 GMT

Hello,

There are two tabs in my attached example, "CASE TABLE" and "CASE PROCESS".

There is a very simple load in CASE TABLE tab.

In the CASE PROCESS tab, I tried to:

1. Pull CASE_ID from CASE TABLE by using RESIDENT LOAD called CASE PROCESS

2. Left Join a bunch of data fields with CASE PROCESS table

3. Use GENERIC LOAD by using RESIDENT LOAD from CASE PROCESS table.

However, I always got errors that "TABLE CANNOT FOUND". Can anyone help me out here?

Thanks,

Becky

Re: Resident Load Error

Peter_Cammaert — Tue, 12 Jul 2016 18:11:59 GMT

You can start with replacing the LOAD option delimiter is '\t' into delimiter is ' '. Your INLINE tables don't contain tabs.

Another one: if your second INLINE table contains field names in mixed case, then why do you try to load them in UPPER CASE? QlikView is extremely case sensitive, except for "keywords" and Function names.

Peter

Re: Resident Load Error

Peter_Cammaert — Tue, 12 Jul 2016 18:14:26 GMT

BTW I don't get the TABLE NOT FOUND error. If you do, add a NOCONCATENATE prefix to the LOAD for CASE_PROCESS. That table looks exactly the same as CASE_TABLE, so QlikView may decide to perform an autoconcatenate all by itself. Which means that there won't be a CASE_PROCESS table.

Best,

Peter

Re: Resident Load Error

Tue, 12 Jul 2016 18:25:52 GMT

Thanks Peter!

These are the three errors I got when executing the script. I changed the script as you mentions above (change to upper case) in Inline, and CASE_PROCESS before LOAD. Those errors are gone. But I got a syn key which is CASE_ID + Receive Date. The way to eliminate the Syn key is to change the name of "Receive Date" to another name in the CASE_PROCESS table?

Re: Resident Load Error

damirm86 — Tue, 12 Jul 2016 18:43:00 GMT

You need to drop the first table.

Re: Resident Load Error

Tue, 12 Jul 2016 18:50:08 GMT

Actually even without adding a NOCONCATENATE prefix to the LOAD, it still works. I got where was the problem. It was script issues, just like you said, the upper case or lower case.

Thanks Peter!

Becky

Re: Resident Load Error

Tue, 12 Jul 2016 19:58:55 GMT

Drop CASE_TABLE? After which script statement?

Re: Resident Load Error

damirm86 — Tue, 12 Jul 2016 20:02:20 GMT

After the first resident load table you can drop CASE_TABLE .

Re: Resident Load Error

damirm86 — Tue, 12 Jul 2016 20:16:01 GMT

Something like this maybe??

Re: Resident Load Error

Tue, 12 Jul 2016 20:19:14 GMT

Thank you Damir. I have extra question is what's benifit to drop the CASE_TABLE? Occupy less ram or?

Re: Resident Load Error

damirm86 — Tue, 12 Jul 2016 20:21:16 GMT

Less ram and a clean data model.

Re: Resident Load Error

Tue, 12 Jul 2016 20:35:52 GMT

I see. Thanks!