Need to concatenate more than 10 fields

[Former Member]

Hi All

in Mapping need to concatenate more than 10 fields , is there any way to make it short can concatenate all in one stretch, instead of using mutiple conctenate statements

please help me

Thanking you

Sridahr

[prateek · Accepted solution]

Other way could be use of UDF. But for this, you need to create a UDF with 10 inputs.

Regards,

Prateek

[Former Member · Accepted solution]

thanks you very much casue already i am using lot of fuction , so thought that there might be some way for this

Thanking you

[prateek · Accepted solution]

If this is a one time activity, better to go for using concatenate function multiple times.

Regards,

Prateek