Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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';
Hi, verify that the date format in your WHERE condition matches the format of the 'LastDate' column in the SAP BW source.
Hi, verify that the date format in your WHERE condition matches the format of the 'LastDate' column in the SAP BW source.