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

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

Thu, 18 Oct 2012 13:19:17 GMT

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.

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

Miguel_Angel_Baeyens — Thu, 18 Oct 2012 13:24:45 GMT

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

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

Thu, 18 Oct 2012 13:29:18 GMT

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

MayilVahanan — Thu, 18 Oct 2012 13:39:25 GMT

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