I want to append latest/current week's data to a file wherein we have 6 month's data(excluding the current week) ,
to do that I am using a peek function to look for the max date in the 6months data,
and then wants to compare it with the latest week's max date , if the date matchs that means we have concatenated the data if it doesn't match then we have to concatenate the latest week's file to 6 Month's file.
For getting latest week's data we are using a REST Connector, 6 months data is stored as qvd
$(maxdate_latest) is the variable to peek into latest max date and $(vmaxdate) is the variable for the 6months max date
I'm using this script
if '$(maxdate_latest)' <> '$(vmaxdate)' then
Reference_data:
load * from reference_qvd2;
concatenate
Streaming_data:
load * from reference_qvd2;
Else
0;
Endif;
