topic Re: Field Not Found Error in QlikView

Field Not Found Error

Wed, 28 Aug 2013 16:26:29 GMT

I'm trying to rename a field in the LOAD statement, but I keep getting an error "Field Id not found".

The field is clearly being selected in the SQL statement. And the ALIAS statement is for the other two fields, as they can be renamed across the entire document, not just this one qvd.

Below is my script.

Any help would be greatly appreciated.

[SF]:

SQL SELECT Account_Extended_Id__c,

Id,

Renewal_Status__c

FROM ACCOUNT;

LOAD Id as SFAcctID, Account_Extended_Id__c, Renewal_Status__c FROM SF.QVD;

ALIAS Account_Extended_Id__c as SFAccountExtendedID, Renewal_Status__c as SFClientStatus;

STORE [SF] INTO SF.QVD;

DROP Table [SF];

Re: Field Not Found Error

abeyphilip — Wed, 28 Aug 2013 16:33:03 GMT

Hi,

Shouldn't it be

LOAD Id as SFAcctID, Account_Extended_Id__c, Renewal_Status__c resident SF?

Regards,

Abey

Re: Field Not Found Error

Gysbert_Wassenaar — Wed, 28 Aug 2013 16:36:47 GMT

Make sure the data from the file SF.QVD actually contains a field named Id.

Re: Field Not Found Error

Oleg_Troyansky — Wed, 28 Aug 2013 17:09:13 GMT

If this is your actual load script verbatim, then it looks like you are missing a (QVD) qualifier in your QVD load:

LOAD Id as SFAcctID, Account_Extended_Id__c, Renewal_Status__c FROM SF.QVD (QVD);

It's very easy to forget when you type your QVD loads manually...

cheers,

Oleg Troyansky