Message Mapping Scenario - Split Issue

[smansari32]

Hi All,

I have similar following requirement could anyone tell me whether this is achievable in SCPI. If yes, Pls help?

Input Xml

<Input>
   <value>1,2,3,4,5</value>

<Input>

Output Xml

<Output>
  <value>1</value>
  <value>2</value>
  <value>3</value>
  <value>4</value>
  <value>5</value>
</Output>

Please let me know the possibilities

Thanks

Ansari

[MortenWittrock]

Hi Ansari

I did, nevertheless, show you a screenshot of the mapping giving your desired output based on your own input 🙂 You probably simplified the problem for the purpose of brevity, and that probably leads to a context issue in the mapping.

Show your actual input and output formats in the question, and show a real input document. That would help tremendously.

Regards,

Morten

[smansari32]

Hi 7a519509aed84a2c9e6f627841825b5a , I completely agree, I am facing context issue it seems. given you input and output xsd below. Please help

[engswee]

Of course it's a context issue - what else is new! 😛

[MortenWittrock · Accepted solution]

Hi Ansari

A user-defined function will solve that for you. Add the following function:

import com.sap.it.api.mapping.*

def void splitByComma(String[] s, Output o, MappingContext c) {
    s[0].split(',').each { v -> o.addValue(v) }
}

Then wire it up as follows:

Simulating with your input data, I get the following result:

Regards,

Morten

[engswee · Accepted solution]

Nice to see you giving Message Mapping some love! 😉

[MortenWittrock · Accepted solution]

Well, the OP did ask specifically about it... 😄

[smansari32 · Accepted solution]

Hi,

Thanks for your answer. But it is not working with my case.. 😞

[smansari32]

Hi 7a519509aed84a2c9e6f627841825b5a , Thanks for your help. but it is not working with my actual scenaio.

I give you my input xsd and output xsd, Please help

I want to split shippingComment field by comma and mapped to TEXT_LINE field

Input_XSD input-xsd.txt

Ouput_XSD output.txt

please remove first letter from output.txt and convert to xsd.

Thanks in Advance

Ansari

input-xsd.txt

output.txt

[MortenWittrock]

Hi Ansari

Add a SplitByValue function after the user-defined splitByComma function, and map the output to TEXT_LINE. Also map splitByComma to E1BPSDTEXT, but without the SplitByValue function. Like this:

That takes care of the context issue. I've tried it, and it works.

Regards,

Morten