Resident Load

[#1]

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,

[settu_periasamy]

Try resident  before while..

[sunny_talwar]

While needs to come after Resident Statement

[Peter_Cammaert]

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.

[#5]

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

[sunny_talwar]

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

[Peter_Cammaert]

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

[#8]

MC is the name I have given to the table.

[sunny_talwar]

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

[Peter_Cammaert · Accepted solution]

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