With Join and without Join

Tue, 14 May 2013 21:33:19 GMT

Hi everyone;

I have a problem with the next query;

CxC:

LOAD
   factura,
   cod_cliente,
   tipo_factura,
   cia_contable,
   cxc_fiscal_year,
   cxc_fiscal_month
FROM Dimensiones\CXC.qvd(qvd);

saldos:
LOAD factura,
     cod_cliente,
     tipo_factura,
     cia_contable,
     cxc_fiscal_year,
     cxc_fiscal_month,
     [date(action_date,'MM-DD-YYYY')],
     saldohome_mxp,
     saldocurr_mxp
FROM Dimensiones\saldos.qvd(qvd);

this query do match with the same name columns and

The resul of this query show me x's number of rows for example 10000 rows

BUT i need the result of this query in one table to insert in a qvd the problem is

when i did do this;

CxC:

LOAD
   factura,
   cod_cliente,
   tipo_factura,
   cia_contable,
   cxc_fiscal_year,
   cxc_fiscal_month
FROM Dimensiones\CXC.qvd(qvd);

Left Join

LOAD factura,
     cod_cliente,
     tipo_factura,
     cia_contable,
     cxc_fiscal_year,
     cxc_fiscal_month,
     [date(action_date,'MM-DD-YYYY')],
     saldohome_mxp,
     saldocurr_mxp
FROM Dimensiones\saldos.qvd(qvd);

The result show me now LESS rows for example 9000 instead of 10000 rows beacause added the word Left Join and this number of rows is incorrect.

Can you help me please???

Re: With Join and without Join

swuehl — Tue, 14 May 2013 22:20:15 GMT

How do you get your count of rows?

Are you doing a count of a field (which one? Distinct or not?) or are you looking at the number of CxC records in table viewer (CTRL-T)?

topic With Join and without Join in QlikView

With Join and without Join

Re: With Join and without Join