3 Replies Latest reply: Mar 4, 2016 4:21 AM by Gourav Sikka RSS

    Qlik Sense SAP Connector Issue

    Gourav Sikka

      Hi Team,

       

      i am facing one issue when i implement delta load in qlik sense during SAP Data Extraction.

      Where clause query on date filter is not working properly .

       

      Please help me on this and would appreciate if you provide the syntax for how we can write the query in qlik sense for SAP Delta Load.

       

      waiting for response !!!

       

      Thanks

      Gourav

        • Re: Qlik Sense SAP Connector Issue
          Chris Bishop

          Hi Gourav,

           

          Which SAP connector are you using? Is it possible to see your where clause?

           

          Is this helpdful?

          T1:
          SQL SELECT PKey, Details
          FROM YOUR_TABLE
          WHERE
          ModificationTime >= #
          $(LastExecTime)#
          AND
          ModificationTime < #
          $(ThisExecTime)#;

          CONCATENATE
          LOAD PrimaryKey, Details
          FROM T1.QVD
          WHERE
          NOT EXISTS(Pkey);

          Inner Join SQL
          SELECT PKey
          FROM YOUR_TABLE;

          IF ScriptErrorCount = 0 THEN
          STORE T1 INTO T1.QVD (qvd);
          LET LastExecTime = ThisExecTime;
          END IF

           

          Chris.

          • Re: Qlik Sense SAP Connector Issue
            Gourav Sikka

            Hi Chris,

             

            Please check the script which i have defined in QLIK SENSE script editor  when i extracted the data from SAP Source.

             

            Sales:

            LOAD 

                      Customer_ID,

                      Modified_Date;

            SELECT

              Customer_ID,

              Modified_Date

            FROM Table

                 where Modified_Date>=  '$(vLast_Date)';

            // Customer_ID='1001';

             

            when i do filer on Customer ID basis then where clause is working fine and gives me perfect result.

            But when i do filter on Modified_Date then this where clause is not working , it is not filtering out the data.

            i don't know may be the syntax of comparing with Date field is different in Qlik Sense.

             

            Please help/Guide me on this.

             

            Thanks

            Gourav