Conditional Concatenation/Appending

Kartik3 — Mon, 23 Sep 2024 09:06:52 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 Concatenation/Appending

zar — Tue, 08 Oct 2024 19:38:25 GMT

Seems like incremental load to me. Try to use https://community.qlik.com/t5/Member-Articles/Incremental-Load/ta-p/1478144 with https://qlikviewcookbook.com/2015/05/better-calendar-scripts/ to get week field you may need.

topic Conditional Concatenation/Appending in App Development

Conditional Concatenation/Appending

Re: Conditional Concatenation/Appending