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! 😛

[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