Split String into multiple fields on target side

[former_member309269]

Dear All,

I need to write the udf to achieve the below (| will have to be removed). For eg:

Single Source Field containing below value:

Emp|EmpName|EmpAddress|EmpPhone

Now on the target side, we have 4 different fields (a,b,c,d). I need to map like this now:

Emp ->a

EmpName->b

EmpAddress->c

EmpPhone->d

Please let me know the the udf code for the same.

[former_member309269]

Any pointers please? I followed other links but it is not working, so looking for the correct udf code. Please let me know.

Regards,

Amita

[markangelo_dihiansan · Accepted solution]

Hi,

You need a context type UDF with four result lists. Something like this:

PS: The sample above is over-simplified but you get the idea

Regards,

Mark

[former_member309269 · Accepted solution]

Thank you very much Mark. Appreciate it 🙂

Regards,

Amita