UDF or Graphical Mapping

[former_member185881]

Hello All

I have a requirement like below:

Source fields              

TXT                                 

AddTXT

Target Field

Node

I want to create Node as many times as AddTXT comes with value Concatinate(TXT+AddTXT). This I have achieved not a issue.

Now I want concatinate should happen only for 1st Node other nodes should contain only value of AddTXT.

e.g.

TXT = 001

AddTXT = James

AddTXT = Dheeraj

AddTXT = Rajesh

Result should be

Node = 001-James

Node = Dheeraj

Node = Rajesh

I believe using Graphical mapping this is not possible so how can I achieve this using UDF.

Thanks

Dheeraj Kumar

[Former Member · Accepted solution]

Hi Deeraj

it should be possible even with graphical mapping by using the index-function (can be found in the "statistic"-group). Combined with an if-then-else you should be able to achieve your desired mapping.

Kind regards,

Thomas

[rcsegovia]

Hello Dheeraj,

Duplicate the target node and do the map required for first item under first one and the other into the second one.

regards,

Roberto.

[Former Member]

Hi Dheeraj

Please use the below code.

In the UDF

TXT = var1

AddTXT = var2

Regards

Osman

[javier_alcubilla]

Hi Dheeraj

Try with index function

Check index = 1 for the concatenate

Regards