Re: Add Data to QVD - Qlik Community

mrainey18 · ‎2017-09-15

I am trying to create a master calendar QVD. This will have a line for everyday in the year.

My goal is to run this once a year and have Qlik create the data and concatenate it with the past years.

Is that possible?

kkkumar82 · ‎2017-09-15

Yes ofcourse, use the logic of "Incremental load" for insert where you will be loading the qvd + your new data, both of them will be concatenated after loading and just create a new qvd with the same name which will replace the old one

containing old + new records

Share some sample so that we can explain the process

passionate · ‎2017-09-15

Why are you trying to Concatenating Master calendar data into QVD.

Do you have a huge date range?

mrainey18 · ‎2017-09-15

We have been having issues with AutoCalendar. We are going to try this and see if it works better. I just wanted to make sure it was possible.

Its not a huge date range. We have some weird formatting requirements from our end user that throws off the AutoCalendar.

mrainey18 · ‎2017-09-15

Using QVD files for incremental load ‒ Qlik Sense

This is great but only solves half the problem. I do not want to load new data from a DB or Excel file. I want to create it in a Qlik script.

How should I do that?

What I'm thinking of doing is using a do while loop to increment a variable by 1. Inside the loop I will do all my formatting and then insert it into an inline table.

The inserting these calculated fields into the inline table is where I'm drawing a blank.

Anonymous · ‎2017-09-15

Maybe create a communal Master Calendar for say this and next decade - then when you load it use a where clause to just bring in the date range you want.

e.g. where [Year] <= year(today())

mrainey18 · ‎2017-09-15

I could but this isn't the only use case I have to use a dynamically created inline table.

rwunderlich · ‎2017-09-15

Why concatenate with past years, why not just generate all the days you need every time?

-Rob

mrainey18 · ‎2017-09-15

I can do either or. It doesn't matter once I have the generated inline table. The concatenate is just an extra step that I choose to skip if I wanted.