Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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
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.
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