Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Not applicable

Orphan tables created by Alias statement

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

OrphanTables.png

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

Tags (2)
1 Solution

Accepted Solutions
Not applicable

Re: Orphan tables created by Alias statement

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

1 Reply
Not applicable

Re: Orphan tables created by Alias statement

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

Community Browser