|
| Some of the line data seems to be missing after using the looping functoid,
could you explain why I see this, and a way to work around this behavior?
I have an 867 EDI structure that, simplified, looks like this
Interchange
Document (many)
Transaction (many)
REF Loop (many)
QTY (many)
I am mapping the REF Loops to a database table, one of the REF loops has the
Order Number, and another other has the Agent Number. I am using the value
mapping (flattening) functoid to map correctly to the specific output schema
properties, as seen below.
-<ns0:after>
<ns0:Vet_Sales_Data BOS_Ord_Num="6638329" Dist_Agent_Code="62004" />
<ns0:Vet_Sales_Data BOS_Ord_Num="6638352" Dist_Agent_Code="62015" />
<ns0:Vet_Sales_Data BOS_Ord_Num="6638362" Dist_Agent_Code="62015" />
<ns0:Vet_Sales_Data BOS_Ord_Num="6638363" Dist_Agent_Code="62005" />
..
However, my ultimate goal is to create a row for each QTY, not for each
Transaction. When I map the QTY to the output, it only maps the first QTY
loop.
-<ns0:after>
<ns0:Vet_Sales_Data BOS_Ord_Num="6638329" Dist_Agent_Code="62004"
BOS_Ship_Qty="1" />
<ns0:Vet_Sales_Data BOS_Ord_Num="6638352" Dist_Agent_Code="62015"
BOS_Ship_Qty="2" />
<ns0:Vet_Sales_Data BOS_Ord_Num="6638362" Dist_Agent_Code="62015"
BOS_Ship_Qty="1" />
<ns0:Vet_Sales_Data BOS_Ord_Num="6638363" Dist_Agent_Code="62005"
BOS_Ship_Qty="1" />
..
I put the looping functoid in, where the input to the functoid is the QTY
element, and the output is the Vet_Sales_Data, so that it will create a new
row for each QTY, and replicate the other fields already generated.
However, when I do, this is the results.
-<ns0:after>
<ns0:Vet_Sales_Data BOS_Ord_Num="6638329" BOS_Ship_Qty="1" />
<ns0:Vet_Sales_Data BOS_Ord_Num="6638352" BOS_Ship_Qty="2" />
<ns0:Vet_Sales_Data BOS_Ord_Num="6638362" BOS_Ship_Qty="1" />
<ns0:Vet_Sales_Data BOS_Ord_Num="6638362" BOS_Ship_Qty="1" />
<ns0:Vet_Sales_Data BOS_Ord_Num="6638363" BOS_Ship_Qty="1" />
<ns0:Vet_Sales_Data BOS_Ord_Num="6638363" BOS_Ship_Qty="6" />
<ns0:Vet_Sales_Data BOS_Ord_Num="6638363" BOS_Ship_Qty="2" />
<ns0:Vet_Sales_Data BOS_Ord_Num="6638363" BOS_Ship_Qty="3" />
<ns0:Vet_Sales_Data BOS_Ord_Num="6638363" BOS_Ship_Qty="1" />
<ns0:Vet_Sales_Data BOS_Ord_Num="6638363" BOS_Ship_Qty="1" />
..
Which is now the correct number of rows, but the Agent code is missing. It
seems to be an issue with multiple REF loops being mapped to a flat
structure, but then below it, there is a looping functoid.
If you would like to see the map, please feel free to email me back!
|
|