2 Replies Latest reply: Apr 14, 2016 3:41 AM by harshal hajare RSS

    Unable to fetch Data from HANA in qlikview due to subquery

    harshal hajare

      Dear all

       

      unable to fetch data from HANA due to subquery is not working.

       

      script is-

       

      BKPF:
      SQL SUBSELECT * FROM "RP2_HANA".BKPF WHERE BUKRS GJAHR BELNR IN (SELECT BUKRS, GJAHR, BELNR FROM "RP2_HANA".BWFI_AEDAT where AEDAT = '$(vExtractionDate)');

      store BKPF into "D:\Harshal\HANA\Final Testing\BKPFAEDAT.qvd";


      please suggest way to to use subquery for HANA in qlikview.


      BElow is the error occurs


      Error: SQL##f - SqlState: 37000, ErrorCode: 257, ErrorMsg: [SAP AG][LIBODBCHDB DLL][HDBODBC] Syntax error or access violation;257 sql syntax error: incorrect syntax near "SUBSELECT": line 1 col 1 (at pos 1)