This content has been marked as final. Show 3 replies
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.
SQL SELECT Account_Extended_Id__c,
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];