Hi All,
i have built an incremental load that uses the following simple logic:
Tbl: Load data from .csv for latest month, create date key '%keyDate'
Set vLatestDate = Peek(%keyDate)
concatenate (Tbl)
Load data from historic.qvd where date key <> vLatestDate
Where I am struggling is - I would like to replace the <>vLatestDate above with a 'NOT EXISTS' clause so that it can load in an optimized fashion... but I can't get the logic to work!
Any help gratefully received! Thanks.
