on 07-30-2007 12:40 PM
Hi All,
Here I require help from you guys..
I am doing message mapping where my source and target structures are almost same.
Source data structure
MT_Source
|_____Records (1..Unbounded)
|___RecordType1 (1..)
|___ RecordType2 (1..)
|___ RecordType3 (1..)
Target data structure
MT_Target
|_____Records (1..Unbounded)
|___RecordType1 (1..)
|___ RecordType2 (1..)
|___ RecordType3 (1..)
But here I suppose to carry only those records from source to target where RecordType1 from source is not null.
Example: - if source is having 100 records and out of that 30 are having null value for RecordType1 then I need to carry only these 30 records to target.
Thanks,
Sunil Bhavsar.
Hi Sunil,
Create the UDF and mapped to MT_Target and in the UDF, take the one inputMT_Source-RecordType1 as Queue and loop all the records and check if it is null then add the record to result otherwise don'ts once you come out from the loop just return those values exist in result.
Thats all your requirement will complete, in the same way map the to the remaining fields with the help of MT_Source-RecordType1.
Warm Regards,
Vijay
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Sunil,
In mapping use createif node funciton. check RecordType1 value to null. If it is null then only it passes the records to target. So you have to map like this:
RecordType1>equals>Null>createif>Records in target. Then if the value is null then only it passes to the target else it will stop.
Regards,
---Satish
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
Thanks to all...
And
http://www.flickr.com/photo_zoom.gne?id=572921073&size=o
Vijay I have awarded points to you....
---sunil
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Sunil
/people/jin.shin/blog/2006/02/07/multi-mapping-without-bpm--yes-it146s-possible
Mapping Simplified - Part I
/people/claus.wallacher/blog/2006/04/17/replication-of-nodes-using-the-graphical-mapping-tool - Replication of Nodes Using the Graphical Mapping Tool
http://help.sap.com/saphelp_nw04/helpdata/en/ee/bf9640dc522f28e10000000a1550b0/frameset.htm
http://help.sap.com/saphelp_nw04/helpdata/en/79/2835b7848c458bb42cf8de0bcc1ace/frameset.htm
/people/michal.krawczyk2/blog/2005/06/28/xipi-faq-frequently-asked-questions
Hope this will help you ...
pls reward if useful
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi
U can create a user defined function to check the value.if it s not null map it to target.
regards
yugapreetha
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
81 | |
10 | |
10 | |
9 | |
7 | |
6 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.