10 Replies Latest reply: Jul 1, 2017 10:23 AM by pavan nallani RSS

    Just an information about "Alias"

    Beaulieu Mathieu

      Hello,

       

      I have juste a little question about the function ALIAS.

      I noticed that ALIAS function works with an XLS loads like this :

       

      Alias Name as NewName;

      TableName:

      LOAD *

      FROM

      [D:\QlikView\Application\Test\DB_test1.xlsx]

      (ooxml, embedded labels, table is Feuil1);

       

      But, this same code doesn't work with a QVD file. QlikView generates a new table named $Orphan_NewName...

      Could you explain to me?

       

      Alias Name as NewName;

      TableName:

      LOAD *

      FROM

      [D:\QlikView\Application\Test\DB_test1.QVD] (qvd);

       

      Thanx,