Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Not applicable

How to Load Data from multiple tables and store it in single QVD

I have three tables which i have joined with a primary key and i would like to have different columns across these tables that i require to form One single QVD. Does anyone know any option or Command.

3 Replies
MVP
MVP

Re: How to Load Data from multiple tables and store it in single QVD

Hi,

If you already did a JOIN, you then only have ONE table in your model. Now do a STORE specifying the name of the first table (not those that where JOINed) and the file you want to create.

Table1:

LOAD *

FROM File1

JOIN LOAD *

FROM File2

JOIN LOAD *

FROM File3

STORE Table1 INTO FileAll.qvd (qvd);

Hope that helps.

Miguel

Not applicable

Re: How to Load Data from multiple tables and store it in single QVD

Thanks for the advise but i know this one and i have tried also but the issue is this that i want specific field to be saved, which i am unable to do so.

Re: How to Load Data from multiple tables and store it in single QVD

HI

Try like this

Store field1,field2 from mytable into filename.qvd(qvd);

Check once in the tableviewer before save the qvd about fieldname and tablename.

Hope that helps

Community Browser