Mapping split by value

[Former Member]

Hello friends,

I have the following scenario where i get data from SQL table via JDBC and map it to an IDOC.

<Row>

<Header Ind>1111<Hearer Ind>

<Det1>5<Det1>

<Det1>5<Det1>

<Det1>5<Det1>

<Row>

<Header Ind>2222<Hearer Ind>

<Det1>6<Det1>

<Det1>6<Det1>

<Det1>6<Det1>

The above is the source Payload. In the Mapping I have taken the Header Ind node and done the below for all the target segments.

Header Ind --- Split by Value [value change] -

---

collapse context --- IDOC

Header Ind --- Split by Value [value change] -

---

collapse context --- EDIDC40

Header Ind --- Split by Value [value change] -

---

collapse context --- EIBPACH08

Header Ind --- Split by Value [value change] -

---

collapse context --- EIBACGL08

My question is where do I map the <row> node too ?? I am still getting an error below

Cannot create target element /ACC_GL_POSTING01/IDOC[2]/EDI_DC40. Values missing in queue context. Target XSD requires a value for this element, but the target-field mapping does not create one. Check whether the XML instance is valid for the source XSD, and whether the target-field mapping fulfils the requirement of the target XSD

Thank you,

Teresa

[Former Member · Accepted solution]

You need to map row context node to destination idoc context node.

[Former Member · Accepted solution]

If i map <row context to destination IDOC then split by value and collapse context is not required?? I would like to genereate a new IDOC every time the header Ind changes.

Thanks,

Teresa