Need the mapping logic

[former_member192392]

Hi Experts ,

I have a scenario where the Source has field name as : AGENCY

And the target has 10 fields like : 

CODE1

CODE2

CODE3

.

.

.

CODE10.

The field Agency is to be mapped with all these 10 target fields with the condition as below

1st value of Agency should go to CODE1

2nd value of AGENCY should go to CODE2

For ex:  I am sending the below data in AGENCY --

A1,A2,A3.......A10.

In the target A1 goes to CODE1

A2 goes to CODE2  ..................A10 goes to CODE10

Please help me with this.

[Former Member · Accepted solution]

Hi Praveen,

You will have to write a UDF for getting this done as this will be possible to pass the data to 10 nodes with graphical mapping..

You can wirte a UDF with one paramter as input and 10 parameters as outout . and map each output with respective target field

In the UDF you can perform the string operations on input string to split on ",".

String[] words = str.split (",");

Thanks and Regards,

Amit Bhagwat