Problem with a WHERE statement

somi — Thu, 02 Sep 2021 08:20:13 GMT

Hello all,

I would like to filter all numbers smaller than 215855772 in the vorgang_status column directly in the script. However, the import to the view always breaks with the error message unknown command (where "vorgang_status" <= 215855772)...

Here is my script:

LOAD "ansprechpartner_dbid",
"bearbeiter_dbid",
"beleg_datum",
bezeichnung,
"vorgang_status",
zahlbetrag;
SQL SELECT "ansprechpartner_dbid",
"bearbeiter_dbid",
"beleg_datum",
bezeichnung,
"vorgang_status",
zahlbetrag
FROM pdserp."public"."pds_rechnung";
where "vorgang_status" <= 215855772;

Would appreciate a response.

Many greetings
Martin

Re: Problem with a WHERE statement

Kushal_Chawda — Thu, 02 Sep 2021 10:31:00 GMT

@somi remove the semicolon(;) as highlighted in red

topic Problem with a WHERE statement in QlikView

Problem with a WHERE statement

Re: Problem with a WHERE statement