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