Skip to Content
avatar image
Former Member

message mapping based on field condition

Hello ALL,

I have a urgent requirement on message mapping.but i am not able to do.

I have five fields empid,department,designation,salry,experiance.

Based on Department i need to spilt the payload at message level.

This is my messages structures.

This is my file data.

Based on department i need to spilt rows data into separate files at mapping level.

ex abap rows data into one file,HR into one file,PI into one file etc....

Please it is urgent help me.

Please your posts as soon as possible.

Thanks and Best Regards,

s.k.prabhakar.

wmtun.png (20.2 kB)
amg5r.png (7.6 kB)
Add comment
10|10000 characters needed characters exceeded

  • Hi, Prabhakar!

    What's your target file type? Is it xml or plain text?

    Regards, Evgeniy.

  • Former Member Evgeniy Kolmakov

    Hi Evgeniy,

    sorry to say this you posted previously mapping successfully working. i did worng at context change.

    My file is moving from sender side but receiver side it wont come.

    I got error "values misssing in queue context cannot create target element at target side". for this error i used node function " map with default value". like this

    but still not resolve the error. is it any useful if i change my source structure as 0.1.

    post your valuable comments,

    Thanks,

    whg9y.png (48.3 kB)
  • Get RSS Feed

4 Answers

  • avatar image
    Former Member
    Nov 17, 2016 at 11:27 AM

    Hello All,

    I changed my source structure is 0.1. but still it showing same error.

    values missing in queue context cannot create target element at receiver side.

    How can i resolve the issue. please help me.

    Thanks,

    Add comment
    10|10000 characters needed characters exceeded

  • Nov 17, 2016 at 12:00 PM

    Hello,

    Please change the target structure occurence.

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Srikanth E

      Hello srikanth,

      I changed as your suggested source 1.1 to target 0.1.

      But still no luck.

      i share my message structure with you check onece. let me understand why this error coming.

      check it once Please make me understand. How can i resolve the issue.

      Thanks,

      s.k.prabhakar.

      6n3tw.png (17.0 kB)
  • Nov 17, 2016 at 01:52 PM

    Hello Prabhakar,

    Press referesh button in the mapping after changing the occurence.

    Add comment
    10|10000 characters needed characters exceeded

    • Hello Prabhakar,

      Its because of multi mapping,since your changing the occurrence of messages additional node of messages with occurrence 0-unbounded will be added,Since your XML after FCC is not satisfying the condition its failing.

  • Nov 19, 2016 at 09:15 AM

    Hi,

    If you want to generate multiple files based on departments that come under payload, then you have to use BPM.
    Because as per my knowledge you cant generate more than one file at a time when you call Receiver File Adapter. So you have to do looping, that is only possible in BPM. If you are too good in Java and have proper knowlege SAP PI Jar Packages, then you can go for Java mapping too.

    But its good, to go for BPM, as data is very less and i don't think you face any problem while doing it using BPM.

    For your error, you change context of all elements that came under payload, but for what?? I didn't get your logic here. And also, share full error taht appearing to you. But in fist look, i can say, due to missmatch with records contexts you are geting this error because u removed all higher context nodes. Now its dificult for system to judge, which empid belongs to whom. But share full error that you are getting.

    Regards,

    Anoop Kumar Rai.

    Add comment
    10|10000 characters needed characters exceeded