Conditional Appending

[Kartik2]

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;

[ali_hijazi]

so what does your script lead to?

[Kartik2]

Its not working properly.

is there anything wrong with the code?