1 Reply Latest reply: Nov 24, 2014 10:49 AM by Marcel Artz RSS

    Orphan tables created by Alias statement

    Marcel Artz

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