9 Replies Latest reply: Sep 8, 2016 11:36 PM by arul settu RSS

    QlikSense Data Manager

    Manish Kachhia

      I am trying to load two attached files in QlikSense using Data Manager. I am getting below script.

       

      [Sales2010]:
      LOAD
        Date(Date#([InvoiceDate], 'YYYYMMDD') ) AS [InvoiceDate],
        [Sales] AS [Sales],
        [Customer] AS [Customer];
      LOAD [InvoiceDate],
        [Sales],
        [Customer]
      FROM [lib://Downloads/Sales2010.csv]
      (txt, codepage is 1252, embedded labels, delimiter is ',', msq);
      
      
      [Sales2011]:
      LOAD [InvoiceDate],
        [Sales],
        [Customer]
      FROM [lib://Downloads/Sales2011.csv]
      (txt, codepage is 1252, embedded labels, delimiter is ',', msq);
      
      
      
      
      
      
      RENAME TABLE [Sales2010] TO [Sales2010-Sales2011];
      
      
      

       

      I don't understand why InvoiceDate from Sales2010 is converted and InvoiceDate from Sales2011 is not getting converted to appropriate date fromat.

       

      The date format in script is

      SET DateFormat='DD/MM/YYYY';

       

      Is this a bug ?

       

      Regards,

      MK