Suggestion for Appending Data

[bharatkishore]

Hi All,

I have a qvd with five fields (A,B,C,D,E)and next month i will generate a new qvd with same five fields but with new data (A,B,C,D,E).

As of now i am doing Tab 1 join Tab 2.

But every month i cannot do same process because if it is 10 months then i have to join 10 times the qvd's.

Incremental i cannot do because as of now i don't have any key to load on that particular date.

Can you please suggest me a better approach.

Thanks,

Bharat

[bramkn]

You can use for each file in filelist()
Or if they have about the same name use a wildcard in the from statement.

For these solutions the qvd's need to be in the same folder. if not you will have to loop through possible dirs aswell.

[Brett_Bleess · Accepted solution]

Another idea would be to create a new QVD every beginning of new month where you load the old cumulative QVD and the month just finished and save that back out to a new cumulative QVD and then use the new cumulative QVD along with each day in the new month etc....  You could do the same thing to keep quarterly or annual files etc.  Best workaround of which I can think on this one, I am sure there are likely better methods as well though.  Check the Design Blog area to see if you can find anything there that might help too if you have not done so already:

https://community.qlik.com/t5/Qlik-Design-Blog/bg-p/qlik-design-blog

Regards,
Brett

[bharatkishore]

Thank you for your reply..