1 Reply Latest reply: Nov 7, 2017 5:45 AM by Mateusz Nitek RSS

    Incremental Load in Script for PostgreSQL - ERROR

    Mateusz Nitek

      Helo guys,


      I wanted to do incremental load for Qlik Sense using PostgreSQL database. I have created qvd file but when I want to use where claus, one error occure.


      Connector reply error: Unable to get column information for the fields that are used in the query: ERROR [42000] [Qlik][ODBC PostgreSQL Wire Protocol driver][PostgreSQL]ERROR: syntax error at or near "09"(Position 257; File scan.l; Line 1005; Routine scanner_yyerror; )

      When I delete this 'where claus' from the script everything is ok.


      Here is the variable:

           LET vModDate=Peek('end_time',0,'ExportSort');


      And here where claus:

          FROM "public"."export_details"

          Where end_time >= $(vModDate);


      Mine script is based on this Incremental Load | Qlikview Training | AKY Online Solutions - YouTube


      Could you please help me?

      Thank you, Mateusz