WHERE Condition not work with SAP BW

[Nin_04]

Hello Everyone,

 I have a Qlik SAP Connectors SAP BW  and i need to use a where condition in my ETL01, to load only the last Date for an incremental load , but when i try to write in my query the  WHERE condition, it don't work. How can I do to solve this problem? Someone could help me?

Thanks in advance !

[Table]:

Load

Field A

Field B

....

;

SELECT

*

FROM  [MySAPtable]
WHERE LastDate = '20230828';

[BrunPierre · Accepted solution]

Hi, verify that the date format in your WHERE condition matches the format of the 'LastDate' column in the SAP BW source.