topic Re: Store tables into .qvd in QlikView

Store tables into .qvd

Thu, 09 Oct 2014 18:35:26 GMT

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`;

Re: Store tables into .qve

Thu, 09 Oct 2014 18:38:38 GMT

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.

Re: Store tables into .qvd

maxgro — Thu, 09 Oct 2014 18:44:02 GMT

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

Re: Store tables into .qvd

Clever_Anjos — Thu, 09 Oct 2014 18:48:06 GMT

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

Re: Store tables into .qvd

ashfaq_haseeb — Thu, 09 Oct 2014 18:49:30 GMT

try this

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

Regards

ASHFAQ

Re: Store tables into .qvd

Thu, 09 Oct 2014 18:56:41 GMT

This worked.

Thanks