Orphan tables created by Alias statement

Mon, 24 Nov 2014 09:30:34 GMT

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...

Re: Orphan tables created by Alias statement

Mon, 24 Nov 2014 15:49:07 GMT

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

topic Re: Orphan tables created by Alias statement in QlikView

Orphan tables created by Alias statement

Re: Orphan tables created by Alias statement