topic Create QVD file from 3 SQL queries in QlikView

Create QVD file from 3 SQL queries

alwinsch — Thu, 30 Aug 2012 12:04:12 GMT

Hi,

I have 3 sql statements.

for example

Customer:

select * from customers

product:

select * from products

salesperson

select * from sales

store customer into test.qvd;

store product into test.qvd;

store salesperson into test.qvd;

my test.qvd file has only the data from salesperson.

I want all the data in one QVD file...

Is this possible?

Thanks.

Re: Create QVD file from 3 SQL queries

Thu, 30 Aug 2012 12:29:48 GMT

it is not possible

qvd is one table (allways)

you can store it in qvw file (but then you could do only binary load all the tables from qvw file )

Re: Create QVD file from 3 SQL queries

giakoum — Thu, 30 Aug 2012 12:48:20 GMT

You also could concatenate the 3 tables into one and then store it. Add a field which you can use to distinguish the records from each table, for example 'Customers' as [Origin Table].

Re: Create QVD file from 3 SQL queries

Thu, 30 Aug 2012 12:51:25 GMT

it is the best idea i think

Re: Create QVD file from 3 SQL queries

alwinsch — Tue, 04 Sep 2012 14:53:29 GMT

Can you give a little example.

Because i don't know what you mean.

I created 3 tables

and how to concatenate?

Or is it better to try and edit my sql script so i have one table in origin?

Re: Create QVD file from 3 SQL queries

carloshernandez — Tue, 04 Sep 2012 16:13:55 GMT

Hello, in my opinion I think it would be easier to unite the pair sql query you have only one table, I can think of something like

Cliente:

select clientes.Cliente,clientes.Nombre,clientes.(loscampos que quieras de la tabla cliente),

productos.Producto,productos.Descripcion,productos.(loscampos que quieras de la tabla Productos),

venta.Movimiento,venta.NumerodeMovimiento,venta.Fechaemision

from clientes,productos,venta

where

Venta.Cliente=Clientes.Cliente AND Venta.Producto=Productos.Producto

Assuming ls tables can be linked via any of the equations where after the end of

I hope you serve

regards

Re: Create QVD file from 3 SQL queries

giakoum — Tue, 04 Sep 2012 17:30:48 GMT

OneTable :

sql select *, 'Customer' as Origin from customers;

concatenate (OneTable)

sql select *, 'Product' as Origin from products;

concatenate (OneTable)

sql select *, 'Sales' as Origin from sales;

Just be carefull. If the queries return common field names, they will be handled as one field. Maybe it is better to replace * with specific field names.