cancel
Showing results for 
Search instead for 
Did you mean: 

Send Multiple field values to Single Target field in Message Mapping

Former Member
0 Kudos

Hi,

My  Requirement is to Map Multiple fields to Single field in Target side.I have to send all the values concatenated and pass the same to target Field in Message Mapping.

We can use Concat function,but more that 15 fields are there.If using concat,the mapping will be complex.

Is there any way to simplify this requirement or we can use any UDF for this,kindly suggest.

Regards,

Madhu

Accepted Solutions (0)

Answers (2)

Answers (2)

former_member312864
Active Participant
0 Kudos

Hi,

It can be achived through simple UDF. Please go through below link for solution

Regards,

former_member184720
Active Contributor
0 Kudos

>>>We can use Concat function,but more that 15 fields are there.If using concat,the mapping will be complex.


I don't think it's complex but  just that it occupies more mapping area


Just write a simple UDF - a one line code and pass all your input variables.



return var1+var2+var3+var4+...+var15;


Former Member
0 Kudos

Hi Madhusudhan,

Instead of writing udf it's better to do the concat using graphical function.  If you want use the udf write the below code.

String output = Var1 + var2 + .... + var15

Return output;

Create the udf with 15 arguments and pass all the inputs to udf.

Thanks,

Satish.