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