Conditional Appending

Kartik2 — Mon, 23 Sep 2024 16:37:58 GMT

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

Endif;

Re: Conditional Appending

ali_hijazi — Tue, 24 Sep 2024 06:42:12 GMT

so what does your script lead to?

Re: Conditional Appending

Kartik2 — Tue, 24 Sep 2024 13:22:36 GMT

Its not working properly.

is there anything wrong with the code?

topic Conditional Appending in App Development

Conditional Appending

Re: Conditional Appending

Re: Conditional Appending