1 Reply Latest reply: Nov 6, 2013 5:56 AM by Gysbert Wassenaar RSS

    Load Data From SQL

    Manish Kachhia

      OLEDB CONNECT32 TO ******

      LOAD BRCODE,
           
      DECDDT,     //This is Timestamp in format ‘YYYY-MM-DD 00:00:00 000’
           
      DECDTIME,
           
      ORDNO,
           
      IVNO,
           
      IVDT,
           
      SR,          //Supplier
           
      PNO,         
           
      PURQTY,
           
      PURAMT,
           
      CURR,
           
      CREAID,
           
      REFERENCE,
           
      BRNO,
           
      ORDTYPE;
      SQL SELECT *
      FROM PPMSDB1.dbo."PMS_PURCHASE";

       

      1) How to write below SQL code in QlikView Script?

       

      Select BRCODE, SR, SUM(PURAMT) From PMS_PURCHASE

      Where (BRCODE = '123') and (DECDDT >= '2013-11-01')

      Group By SR, BRCODE

      Order By SUM(PURAMT) DESC

       

      2) How can I convert DECDDT in ‘DD/MM/YYYY’