Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I want to apply incremental load to an existing QVD file.
The data to be downloaded is from my ERP Navision.
When i use the following expression in Excel, it works fine.
LET vIncrementalExpression = 'WHERE ModDate >=' & peek('maxdate');
But when i try to use this as part of SQL select statement, i get syntax error.
Can anyone help me please.
Hi Kartik.
Can u check the datetime format required by SQL. After getting maxdate using peek, it will be required to format in same way as required in SQL.
Ashish,
Actually i tried entry number (unique number) also.
Even that is not working.
