Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
cancel
Showing results for 
Search instead for 
Did you mean: 
Nin_04
Contributor II
Contributor II

WHERE Condition not work with SAP BW

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';

Labels (1)
1 Solution

Accepted Solutions
BrunPierre
Partner - Master
Partner - Master

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

View solution in original post

1 Reply
BrunPierre
Partner - Master
Partner - Master

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