How to map multiple source fields to single target field

[#1]

Hi ,

I have to map multiple source fields to a singlr target field. How can I achieve this ? Should i use UDF ? If so what code should be in UDF.

Below is my mapping . I just tried but I dont understand what is to be written in UDF Title which i have created.

Here I have to check source field with a string and if that equals then i need to map to target field.

Please help me how to acheive this.

Thanks

SARIKA

[Former Member]

Hello Sarika,

If your concatenation your source strings no need of UDF,concat funciton will do.

To understand what is written in the code,Post it so that we can analyse the same.

[Former Member]

I can't concate the source fields.The requirement is not like that.

I just mapped like  that to give a screenshot here . I didt write any code in UDF.

[Former Member]

Hello Sarika,

Just share the code ,Let it be written by anyone.

And let us know what logic your using to combine the strings.

[Former Member]

Hi Raghu,

I just created a UDF with 5 inputs. I did not write any code inside. I was just trying creating UDF.

And i dont want all those fields to be concatenated and sent to target field.

[Former Member]

Thats fine Sarika.

Please tell what wish to acheive? you want to include any specific rule?

[Former Member]

I have to Map few sourcce fields to one Target field.

In the above mapping I have shown you if ZWHI equals some value ZTOR7 then it should be mapped to Target field TDTEXTTYPE .

And similarly if ZCBT, Zcustom equals some value then they also need to be mapped to TDTEXTTYPE at target.

This I want to achieve.

[Former Member]

Hello Sarika,

This can be done using normal mapping functions,Try as per Sam;s comment,

If its not working let us know,will help you out.