Store tables into .qvd

[#1]

Hi everybody.

I have a qvw file with 3 tables. I dont have conection to the server, i only have the tables and i can see it, but i can´t reload the data.

I need to check if the data is ok, and i´d like to qualify a few fields beause i have a giant link table and i cant see cleary because i can´t see the tables with the preview.

I´d like to store the 3 tables into 3 separate fields

What i have to do ?

Thanks

For example in

ODBC CONNECT TO Licitaciones123 (12, XPassword is 12);

Presupuestos:

SQL SELECT *

FROM qlikview.presupuestos;

Presupuestos_items:

SQL SELECT *

FROM qlikview.`presupuestos_items`;

Presupuestos_pedidos:

SQL SELECT *

FROM qlikview.`presupuestos_pedidos`;

[#2]

I tried using store, but now i realise that even if i use store i have the same error because i dont have conecction to the db.

[maxgro · Accepted solution]

if you have a .qvw with data (tables) and you can't reload it

you can use a binary load in a new .qvw and in the new .qvw store the tables in qvd

[Clever_Anjos]

Is your qvw already loaded with data?

Try to export each table doing

1) Add a table with the columns you want

2) Right click and Export and select qvd file format

With those QVD´s you can create another qvw and test your data

[ashfaq_haseeb]

try this

Evolution of a QVD Extracting Application (the .QVW Juicer)

Regards

ASHFAQ

[#6]

This worked.

Thanks