i have 6 tables loaded into qlikview in 6 tabs? i ... - Qlik Community

Report Inappropriate Content · ‎2014-07-07

i have 6 tables loaded into qlikview in 6 tabs? i want create a single qvd for all 6 tables ? i dont want 6 qvds i want only one qvd?how?

marcus_malinow · ‎2014-07-07

A couple of approaches

JOIN

or

CONCATENATE

Which is appropriate is dependant on your data structures. Are all your tables structured in the same way? Is data in one table exclusive to that in another. If so, CONCATENATE.

Or is the data related. That is you have records in different tables which relate to each other. If so, JOIN.

marcus_malinow · ‎2014-07-07

http://community.qlik.com/message/441911#441911

See this discussion for some of the basics

sasikanth · ‎2014-07-07

Hi

Irrespective of How many tables that you have , one thing is sure

Finally you can store a single table into QVD,

if you have n number of tables , if you dont want to merge them , then you have to create n QVDS

Others wise go For CONCATENATE , JOIN....Use these to combine all your tables in to one and then Store the Single result set in to QVD..