4 Replies Latest reply: Jan 16, 2018 3:44 AM by Caroline Huet RSS

    Data appears in date format instead of number format after crosstable transformation

    Caroline Huet

      Hello,

       

      I used a crosstable transformation to transform my pivot table. One of the new column which is supposed to be cadences is writen as a date and not as a number.

      I don't manage to transform it as a general format.

       

      My code is written below

       

      tabCadence:

       

      CrossTable (DateCadence,Cadence , 4) load *;

       

      LOAD *

       

      FROM [lib://Qlik Essai1/cadences_test.xlsx]

      (ooxml, embedded labels, table is Feuil1);

       

      NoConcatenate

       

      load  Programme,

       

          Client,

         

          Code,

         

          DateCadence,

         

          num#(Cadence) as Cadence;

       

      LOAD * Resident tabCadence;

       

      Drop table tabCadence;

       

      Do you have an idea ?

       

      My raw data are attached

       

      Thanks