topic Re: Issue with load * resident in QlikView

Issue with load * resident

Thu, 26 Feb 2015 09:53:36 GMT

Dear community,

What is wrong with this syntax?

HRP1001Temp2:
noconcatenate load * resident HRP1001Temp1
Order By RecordKey asc, Beginndatum.BEGDA asc, Endedatum.ENDDA asc;
drop tables HRP1001Temp1;

I´m getting an error message "field not found"

Many thanks in advance,

Leonardo

Re: Issue with load * resident

PradeepReddy — Thu, 26 Feb 2015 10:01:01 GMT

try by removing the Order Clause...

HRP1001Temp2:
noconcatenate load * resident HRP1001Temp1;
drop tables HRP1001Temp1;

Re: Issue with load * resident

datanibbler — Thu, 26 Feb 2015 10:03:34 GMT

Hi,

you were trying to order that table by fields from a different table, judging from the prefixed table_name - only the first field you want to order by seems to be in the primary table, that will work.

To sort by the others, you would have to join those fields.

HTH

Best regards,

DataNibbler

Re: Issue with load * resident

Thu, 26 Feb 2015 10:06:07 GMT

OK, thanks, but how can I order then?

I originally load from Excel into table HRP1001Temp1 simply because I apparently cannot order there; then I do the load resident into HRP1001Temp1 for the purpose of ordering and using cross-records (peek) functions....

Re: Issue with load * resident

CELAMBARASAN — Thu, 26 Feb 2015 10:15:54 GMT

Hi,

While seeing the error message you will get to know which field is making the problem. After finding the field go and check for proper field name (May be there may different in cases because QlikView is Case Sensitive ).