Question Re: Message Mapping Scenario - Split Issue in Technology Q&A

Message Mapping Scenario - Split Issue

smansari32 — Mon, 24 Jun 2019 12:40:05 GMT

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

Re: Message Mapping Scenario - Split Issue

MortenWittrock — Mon, 24 Jun 2019 13:08:03 GMT

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

Re: Message Mapping Scenario - Split Issue

engswee — Tue, 25 Jun 2019 01:25:52 GMT

Nice to see you giving Message Mapping some love! 😉

Re: Message Mapping Scenario - Split Issue

MortenWittrock — Tue, 25 Jun 2019 07:31:30 GMT

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

Re: Message Mapping Scenario - Split Issue

smansari32 — Tue, 25 Jun 2019 08:54:22 GMT

Hi,

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

Re: Message Mapping Scenario - Split Issue

MortenWittrock — Tue, 25 Jun 2019 09:13:26 GMT

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

Re: Message Mapping Scenario - Split Issue

smansari32 — Tue, 25 Jun 2019 09:24:13 GMT

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

Re: Message Mapping Scenario - Split Issue

smansari32 — Tue, 25 Jun 2019 09:26:41 GMT

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

Re: Message Mapping Scenario - Split Issue

MortenWittrock — Tue, 25 Jun 2019 10:56:50 GMT

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

Re: Message Mapping Scenario - Split Issue

engswee — Wed, 26 Jun 2019 01:22:20 GMT

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