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
