consolidate 2 qvd files into one

[dreweezy]

I am looking to take my existing qvd files and merge them into one qvd file for maintenance issues. Currently the two tables/qvds are associated through a column field. Is this possible in Qlik Sense? Do I need to bring in the 2 tables into an app then run a script in the data load editor to push out the consolidated qvd into a working folder? Thanks all.

[Vegar]

You could try @rwunderlich approach for sorting a datamodell into a single qvd. You'll find a guide/description on his webpage QlikView Cookbook. https://qlikviewcookbook.com/2016/11/storing-a-data-model-in-a-single-qvd/

[dreweezy]

Hi Vegar, thanks. Although I do not think this one applies to me this was definitely an interesting read and will be bookmarked for the future.

[Vegar]

Ok, could you try to explain your issue again? What do you mean by consolidate? Maybe a sample picture for input and desired output?

[dreweezy]

I currently have 2 qvd that I associate using Line_ID and Budget_ID. Now, we are getting a 3rd new table/qvd which I need to join using multiple fields. 

You can see the 3rd table has 6 fields I need to associate on but 2/6 is coming from table 1 and 4/6 is coming from table 2 . My initial thought would be to consolidate qvd files 1 and 2 into one qvd and overlay the third file on top joining them on those respective 6 fields making it seamless. I am sure there is a better, efficient, and smarter way. I don't think Qlik allows you to associate multiple fields so my assumptions is to be using an inner join although I'd like to have all the fields available even if it is a null value. I hope this makes more sense, please let me know if it doesn't.

Thank you.

[Vegar]

What about something like this?

Load
Line_ID as Budget_ID,
*
From Table1;
Join LOAD
*
From Table2;
Join LOAD
*
From Table2;
Join LOAD
*
From Table3;