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

[#1]

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.

[Miguel_Angel_Baeyens]

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

[#3]

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.

[MayilVahanan]

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