Skip to Content
0

Split String into multiple fields on target side

Sep 01, 2017 at 10:11 PM

69

avatar image
Former Member

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.

10 |10000 characters needed characters left characters exceeded
Former Member

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

0
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Best Answer
Mark Angelo Dihiansan Sep 04, 2017 at 07:36 AM
1

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


test.png (21.7 kB)
test.png (18.8 kB)
test.png (13.3 kB)
Show 1 Share
10 |10000 characters needed characters left characters exceeded
Former Member

Thank you very much Mark. Appreciate it :)

Regards,

Amita

1