3 Replies Latest reply: Aug 28, 2013 1:09 PM by Oleg Troyansky RSS

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