topic Re: Suggestion for Appending Data in QlikView

Suggestion for Appending Data

bharatkishore — Tue, 04 Jun 2019 12:12:07 GMT

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

Re: Suggestion for Appending Data

bramkn — Tue, 04 Jun 2019 13:21:24 GMT

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.

Re: Suggestion for Appending Data

Brett_Bleess — Mon, 08 Jul 2019 21:23:25 GMT

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

Re: Suggestion for Appending Data

bharatkishore — Wed, 24 Jul 2019 12:46:29 GMT

Thank you for your reply..