Orphan tables created by Alias statement

[#1]

I have something quite weird going on... every alias created is generated in an Orphan table and the alias is NOT executed...

See also discussion earlier with HIC on his blog "How to Rename Fields".

JDE91_AliasMapping:

Load

ColumnName,

ColumnDesc

FROM $(QVD)\JDE91_Alias.qvd (qvd)

Where Not Exists(ColumnName);

For vFieldNo = 0 to NoOfRows('JDE91_AliasMapping')

  Let vFromName = Peek('ColumnName',vFieldNo,'JDE91_AliasMapping');

  Let vToName = Peek('ColumnDesc',vFieldNo,'JDE91_AliasMapping');

  Alias [$(vFromName)] as [$(vToName)];

Next vFieldNo

Any thoughts on this? Please find the app attached.

Thank you in advance!

Marcel

PS: I run this on QV version 11.20.12354.0 SR6 64-bit...

[#2 · Accepted solution]

Dear all,

I have just found the solution... The renaming does not work together with optimized loads... just put where 1=1 in every load statement and it works.

HIC, thanks for the solution!

Regards,
Marcel