Could it be the order in which you are issuing the HidePrefix and the Load in your script - or perhaps another HidePrefix already in your document?
Another thing I would try is explicitly putting the field name in the load:
Not that this *should* make any difference.
How do we rename a qualified field (eg: TableName.FieldName) to a hidden field?
I've tried few combinations but they still don't work:
a. "[FieldName] as [~FieldName]"
b. "[Fieldname] as ~FieldName
The field will still be available and visible for selection in the sheet. If it is not qualify ("FieldName"), then it works.
Thank you in advance