Skip to Content

mapping requirement for spilting payload

Nov 14, 2016 at 01:31 PM


avatar image

Hello ALL,

I have five fields empid,company,designation,city and country. i want to spilt the data based on the city at message mapping level.

How can i do mapping at message mapping level.


10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

3 Answers

Raghuraman S Nov 14, 2016 at 01:47 PM

Hello Prabhakar,

Is it for each city the target root node need to be generated?

You can try something like below

City---->Splitbyvalue----->Root Node.

Show 1 Share
10 |10000 characters needed characters left characters exceeded

Hello Raghuraman,

Based on city i need to spilt all fields data records separatly.


Raghuraman S Nov 14, 2016 at 02:14 PM

Try the below logic

capture.png (5.1 kB)
Show 2 Share
10 |10000 characters needed characters left characters exceeded

hello Raghuraman,

my input file is

here hyd having two records so i want to spilt hyd records into one file and Bangalore into one file and pune into another.


vuz8y.png (3.2 kB)

U need to use multmapping , firstly sort the records as per the city then generate the target message depending on the country.

Evgeniy Kolmakov Nov 14, 2016 at 11:59 PM

Hi Prabhakar!

Actually, it's a simple message mapping in your case as your message structure isn't much complicated. You can use mapping of your source message to the same structure with occurence 0..unbounded (split mapping).

In my case all of my source fields are in context of MT_Emp_Data.

Reagrds, Evgeniy.

Show 5 Share
10 |10000 characters needed characters left characters exceeded

Hello evgniy,

i used your mapping but my payload is not spilliting based on department.

please it is urgent because it took lot time so do need ful and post mapping.



i will post my source structure and Target structure.

Based on department i need to spilt this file data.

All departments rows data spilt into diffrent files.

ex: Abap rows data one file, pi rows data one file,HR rows data one file etc...

I am not able to fix the issue and mapping.

please any one can help me as soon as possible.

Thanks and Bets Regards,


hello these are my structure and file data to spilt based on department.

Thanks and Best Regards,


Sorry, can't see anything.

Regards, Evgeniy.


Hello Evgeniy,

your previously posted mapping working fine.

message monitoring level i got this error " values missing in queue context cannot create target elemnt.

so i got one blog on scn they siad put source structure as 0.1 i did like that also, But still same error.How can i used map with default value between source and target fields.