Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
bharatkishore
Creator III
Creator 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
Brett_Bleess
Former Employee
Former Employee

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 do not forget to use the "Accept as Solution" button on any post(s) that helped you resolve your problem or question.
I now work a compressed schedule, Tuesday, Wednesday and Thursday, so those will be the days I will reply to any follow-up posts.

View solution in original post

3 Replies
bramkn
Partner - Specialist
Partner - Specialist

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
Former Employee
Former Employee

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 do not forget to use the "Accept as Solution" button on any post(s) that helped you resolve your problem or question.
I now work a compressed schedule, Tuesday, Wednesday and Thursday, so those will be the days I will reply to any follow-up posts.
bharatkishore
Creator III
Creator III
Author

Thank you for your reply..