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