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  [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:
And here where claus:
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