Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

Loading multiple source QVDs into one transformed QVD

I have 6 QVD's that I created. I then took those QVD's and brought them into a new QVW to link them and create a data model. I want to then load that data model into a transformed QVD for use throughout the company.

But I realized I've never brought a whole model (ie multiple qvds linked together) into one QVD.

How do I do this?

1 Solution

Accepted Solutions
Not applicable

Re: Loading multiple source QVDs into one transformed QVD

Correct, you could join all the data into a single fact table, this isn't always the perfect solution since it can be RAM heavy, would a Binary load suit your load?

4 Replies
Not applicable

Re: Loading multiple source QVDs into one transformed QVD

A QVD is 1 table, if you are talking about a binary load you can load multiple tables into another QVW by selecting table files and picking that QVW to open.  It isnt a QVD and doesnt have the load optimization.

Not applicable

Re: Loading multiple source QVDs into one transformed QVD

So if I have a QVW that I brought multplie QVDs into to make a data model, I can't then export that whole data model into one QVD?

Would the solution be to join all the QVD's into one table in my model?

Not applicable

Re: Loading multiple source QVDs into one transformed QVD

Correct, you could join all the data into a single fact table, this isn't always the perfect solution since it can be RAM heavy, would a Binary load suit your load?

Not applicable

Re: Loading multiple source QVDs into one transformed QVD

Binary load is what I'm looking for. Thank you!