Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

bharatkishore
Contributor III

Suggestion for Appending Data

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

1 Solution

Accepted Solutions
Support
Support

Re: Suggestion for Appending Data

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

To help users find verified answers, please don't forget to use the "Accept as Solution" button on any posts that helped you resolve your problem or question.
3 Replies
Partner
Partner

Re: Suggestion for Appending Data

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.
Support
Support

Re: Suggestion for Appending Data

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

To help users find verified answers, please don't forget to use the "Accept as Solution" button on any posts that helped you resolve your problem or question.
Highlighted
bharatkishore
Contributor III

Re: Suggestion for Appending Data

Thank you for your reply..