Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
try by removing the Order Clause...
HRP1001Temp2:
noconcatenate load * resident HRP1001Temp1;
drop tables HRP1001Temp1;
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
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....
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 ).