incrimental load

[maniram23]

hi experts,

Every day morning 7.30 am my dash board data Is refreshed but last data is not updated. how will you handle this section?

[#2]

Hi Mani,

In your incremental load logic ,put this logic

Last_Updated_Date:

Load
Date(Max(DateField),'YYYY-MM-DD') as MaxDate
FROM
Folder\abc.qvd]
(qvd);

Let Last_Modified_Date=peek('MaxDate',0,Last_Updated_Date);

This will Capture the max date from the qvd.

Hope this will help you!!!

Thanks,

Shekar.