Mapping

[Former Member]

Dear Friends,

I have one small doubt in mapping.

Source: Target

Name1----

---

>FirstName

Name2 amother field from source also should be mapped to same target Firstname.

How can i map 2 fields from source to same field in Target.?

[Former Member · Accepted solution]

Hi Renu,

please refer my previous reply..but If the occurence of target field is not more than one then you can map as shown below

Field1---->Concat--------->Concat----->TargetField
Field2-----/            field3/

Concat is the standard function in the Text function category.(double click on the concat function to specify the properties if you concat all these three field by space then give space )

[Former Member]

Hi Renu,

There are many inbuild functions while creating graphical mapping in XI. You can try all those according to the requirement.For this requirement you can try TEXT function -

---

>Concat.

Thankd and Regards,

Nutan

[former_member183908]

Hi Renu,

-->So it will be better for you to search in SDN . I feel it is a very basic question so follow the below blogs to get an idea on the mappings.

/people/sravya.talanki2/blog/2005/08/16/message-mapping-simplified--part-i

/people/sravya.talanki2/blog/2005/12/08/message-mapping-simplified-150-part-ii

Thanks

[jyothi_anagani]

Hi Renu,

Map Like This.

Name1---------\
                ------->Concat[ ]-------->FirstName
Name2---------/

In Concat Function give space or soimething you want as seperator.

Thanks.

[Former Member]

Dear friends,

My target field(Firstname) is already mapped to Name1 (source) - this for example

I have 3 fields in source which i need to map to same target field( Firstname)

[aashish_sinha]

Hi renu,

>> My target field(Firstname) is already mapped to Name1 (source) - this for example .I have 3 fields in source which i need to map to same target field( Firstname)

if 1 source field is already mapped to 1 target field, then you can't map it again , otherwise its mapping with other source will be removed.

To map all source field to on target field, use Concat, as suggested by everybody here.

regards

Aashish Sinha

[Former Member]

Hi Renu ,

How can i map 2 fields from source to same field in Target.?

-

---

> The mappingv is done as per the traget , not as per the source .

1. either you concatenate both source field and than map it to target .

2. Map it to one of them

Regards ,

[Former Member]

if the target field occurence is more than 1 then you can duplicate the target field(by right clicking on the field and selecting Duplicate subtree) In this way you can map more than one source field to one target field.

for details refer http://help.sap.com/saphelp_nw70/helpdata/en/2f/5bc63d15431352e10000000a114084/content.htm

[Former Member]

use the Text function CONCAT