concatenating multiple source fields

[former_member587006]

Hi All,

I am working on a scenario which is a proxy-to-jdbc wherin there are multiple(around 30 fields) source fields which are to be concatenated and mapped to a single target field.

The type of the fields on the source side are different.

can any one please help me in doing this.

thanks in advance,

vikram

[MichalKrawczyk · Accepted solution]

Hi,

>>>The type of the fields on the source side are different.

if the type is different you need to write a user defined function

in which you can change/check the type

Regards,

michal

[former_member587006 · Accepted solution]

Hi Thank You,

But as there are around 10 records on the source side and in each record there are 30 fields , all the 30 fields for each of the 10 records has to be passed to the UDF which is a bit complex.

Is there any alternate way to do this?

[Former Member · Accepted solution]

Hi ;

If you have all the 30 fields same in these records then you can use a context level UDF to make it a bit simple.

Mudit

[Former Member]

Hi;

Use a User Defined Function where in you will concat all the field values.

Input to the UDF will be the Field values.

UDF

return F1F2F3+.......F30;

Mapping

Multiple fields -

---

UDF --- Target Field

Mudit

[Former Member]

Hi,

When u have multiple source fields and then u want send to a single field in the target side then create user defined function with the no of arguments in the source side and by using this user defined function u can map to the receiver side.

Rewards points if useful,

Regards,

Srinivas.D

[bhavesh_kantilal]

Either use the Standard Concact function or write a uSer Defined function.

regards

Bhavesh

[santhosh_kumarv]

Hi Karanam

U have to write an UDF or use the concat function.

Regards

Santhosh

*If found Usefull Reward Points*