Field Not Found Error

[#1]

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

[abeyphilip]

Hi,

Shouldn't it be

LOAD Id as SFAcctID, Account_Extended_Id__c, Renewal_Status__c resident SF?

Regards,

Abey

[Gysbert_Wassenaar]

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

[Oleg_Troyansky]

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