on 07-11-2014 2:20 PM
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
>>>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;
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
85 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.