Incremental Load in Script for PostgreSQL - ERROR

mateusz_nitek — Mon, 06 Nov 2017 19:13:23 GMT

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

Re: Incremental Load in Script for PostgreSQL - ERROR

mateusz_nitek — Tue, 07 Nov 2017 10:45:21 GMT

Ok I know, should be in ' xx ':

And here where claus:

FROM "public"."export_details"

Where end_time >= '$(vModDate)';

topic Incremental Load in Script for PostgreSQL - ERROR in Connectivity & Data Prep

Incremental Load in Script for PostgreSQL - ERROR

Re: Incremental Load in Script for PostgreSQL - ERROR