Please help me understand LOAD keyword behaviour

Tue, 23 Feb 2010 03:54:58 GMT

Hi,

Iam loading 2 tables, the first table is an invoice table, and the second one is a production table.

Both share the same field "ItemCode" and "ItemName", although not all items are on both tables

When I load the first table I use the Load method, the second table Im loading it directly from SQL.

When I load them both directly FROM SQL there is no problem, but when I use the LOAD keyword on the first table, some Items in the production table are not appearing. I want to understand this behaviour because I want to start using STORE and LOAD to do PARTIAL Loads. So before I dive into that I hope someone can help me understand this behaviour.

Thank you,

Jose.
































NOCONCATENATE

facturas:
LOAD

Fecha_Entregas

 as Fecha
,CardCode_Entregas as CardCode
,ItemCode_Entregas as ItemCode
,ItemName_Entregas as ItemName
,Quantity_Entregas as Quantity_Facturas
,InvntryUOM_Entregas as InvntryUOM
,Kilos_Entregas as Kilos_Facturas
,MonthDimension_Entregas as MonthDimension;
SQL




 
SELECT

D.DocDate

 as Fecha_Entregas
,D.CardCode

 as CardCode_Entregas
,D.CardName

 as CardName_Entregas
,D1.ItemCode

 as ItemCode_Entregas
,IT.ItemName

 as ItemName_Entregas
,D1.Quantity

 as Quantity_Entregas
,IT.InvntryUOM

 as InvntryUOM_Entregas
,(IT.SWEight1*D1.Quantity)

 as Kilos_Entregas
,CONVERT(varchar(20),MONTH(D.DocDate))

 + CONVERT(varchar(20),YEAR(D.DocDate)) as MonthDimension_Entregas
FROM



 OINV D INNER JOIN INV1 D1 ON
D.DocEntry

 = D1.DocEntry right outer JOIN OITM IT ON
IT.ItemCode

 = D1.ItemCode;
REM SECOND TABLE:





















NOCONCATENATE

Entrada_Produccion:
SQL




 
SELECT

E.DocDate

 as Fecha
,E1.ItemCode

 as ItemCode
,IT.ItemName

 as ItemName
,IT.InvntryUOM

 as InvntryUOM
,sum(E1.Quantity)

 as Quantity_Entrada_Produccion
,SUM(e1.LineTotal)

 AS CostoTotal_Entrada_Produccion
,SUM(e1.Quantity*isnull(it.sweight1,0))

 as Kilos_Entrada_produccion
FROM
 



 = E1.DOCENTRY INNER JOIN OITM IT ON
IT.ItemCode

 = e1.ItemCode INNER JOIN OWOR W ON
W.DocEntry

 = E1.BaseEntry

WHERE

 E1.BASETYPE = 202 AND W.Type <> 'D' AND GROUP BY e.DOCDATE, e1.itemcode, it.itemname,
it.invntryUOM; OIGN E INNER JOIN IGN1 E1 ON
E.DOCENTRY

[\code]
 </body>

topic Please help me understand LOAD keyword behaviour in QlikView

Please help me understand LOAD keyword behaviour