Discussion Board for collaboration on QlikView Scripting.
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".
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)];
Any thoughts on this? Please find the app attached.
Thank you in advance!
PS: I run this on QV version 11.20.12354.0 SR6 64-bit...
Go to Solution.
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!