mapping requirement for spilting payload

[Former Member]

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.

Thanks,

[former_member190293]

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.

[Former Member]

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.

Thanks,

[Former Member]

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,

[Former Member]

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

Thanks and Best Regards,

[former_member190293]

Sorry, can't see anything.

Regards, Evgeniy.

[Former Member]

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.

Thanks,

[former_member186851]

Try the below logic

[Former Member]

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.

thanks,

[manoj_khavatkopp]

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

[former_member186851]

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.

[Former Member]

Hello Raghuraman,

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

Thanks,