9 Replies Latest reply: Mar 21, 2013 9:30 AM by Ankri Laurent RSS

    Help : load all the files and insert calculated columns

    Ankri Laurent

      Hi

       

      I want to load all the colums of a qvd file :

       

      LOAD * FROM

      \\As01\qlikview\loader\QV_TOU_FACTURATION.QVD

      (qvd);

       

      but I also want to add some other calculated columns like

      year( DATE_ARRIVEE_PRODUIT) as YEAR_ARRIVEE_PRODUIT,

       

      What is the syntax I have to use in the expression loader.

       

      It works if I write all the colums that exist in the qvd file:

      LOAD

           CS_PID,

           DATE_ARRIVEE_PRODUIT,

           year( DATE_ARRIVEE_PRODUIT) as YEAR_ARRIVEE_PRODUIT,

           ....

           ....

           ...

           ....

      FROM

      \\As01\qlikview\loader\QV_TOU_FACTURATION.QVD

      (qvd);

       

      But I have enormously colums and I would prefer to charge all the colums in one expression by using " * "

       

      Thanks for your help

       

      Laurent