Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Not applicable

Field Not Found Error

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];

3 Replies
abeyphilip
Contributor II

Re: Field Not Found Error

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

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


talk is cheap, supply exceeds demand
MVP
MVP

Re: Field Not Found Error

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

Community Browser