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

[mateusz_nitek · Accepted solution]

Ok I know, should be in ' xx ':

And here where claus:

    FROM "public"."export_details"

    Where end_time >= '$(vModDate)';