topic Re: Resident Load in QlikView

Resident Load

Fri, 26 Feb 2016 16:08:01 GMT

Hi All,

Can someone direct me towards what I'm doing wrong here? I'm to do a Resident Load of the table above called MC but some odd reason it shows an error.

Thanks in Advance,

Re: Resident Load

settu_periasamy — Fri, 26 Feb 2016 16:12:42 GMT

Try resident before while..

Re: Resident Load

sunny_talwar — Fri, 26 Feb 2016 16:13:46 GMT

While needs to come after Resident Statement

Re: Resident Load

Peter_Cammaert — Fri, 26 Feb 2016 16:15:42 GMT

Well, the syntax of a LOAD statement is actually different. The structure of a LOAD statement is like this:

1-OptionalTableName:

LOAD 2-WhatToLoad

3-FromWhereToLoadIt

4-OptionallyHowToLoadIt;

You exchanged part 3 (the RESIDENT stuff) with part 4 (the WHILE stuff) which is illegal.

So to make it work you should only change the order of the parts.

Re: Resident Load

Fri, 26 Feb 2016 16:25:27 GMT

When I run the reload script it shows an error field not found.

Re: Resident Load

sunny_talwar — Fri, 26 Feb 2016 16:43:08 GMT

Is MC the correct table name (the table right above is the one you seem to be using, but can't see the name)?

Re: Resident Load

Peter_Cammaert — Fri, 26 Feb 2016 16:45:28 GMT

In Qlikview, every name is case sensitive. Check the spelling of table names.

Re: Resident Load

Fri, 26 Feb 2016 16:46:35 GMT

MC is the name I have given to the table.

Re: Resident Load

sunny_talwar — Fri, 26 Feb 2016 16:57:18 GMT

Everything looks good to me. May be if you can share your app and the qvd, one of us can try to reload the document at our end and see what we see

Re: Resident Load

Peter_Cammaert — Fri, 26 Feb 2016 16:59:10 GMT

Put the following statement immediately after the MC LOAD statement:

EXIT SCRIPT;

Then Reload, open the Table Viewer, and check what columns are available in this MC table.

Peter