Assignment Help

[Former Member]

Hello,

In MDM we have full name stored as

FULL NAME1 : lastname , firstname

FULL NAME2: lastname firstname

in FULL NAME1 we have delimiter as , (comma)

can we run assignmet that when ever in Full name field we have delimiter as ,(comma) split last name and first name and assign last name to last name field and first name to first name field in MDM?

In there any other work around?

Kunal

[Former Member]

Hi Kunal,

Yes the requirement can be achieved.

Create two Assignment Expressions

1. Assignment Field would be Lastname and write the expression as RIGHT (FULLNAME, FIND(FULLNAME,","))

2. Assignment Field would be Firstname and write the expression as LEFT (FULLNAME, FIND(FULLNAME,",") -1)

Also you need to create a validation which checks whether FULLNAME contains "," and the expression would be IF (FIND(FULLNAME, ",") > 0).

Create one workflow and set the Trigger Action = Manual. Design of the workflow would be

Start -> Branch(Give the Validation name) -> Assign1 (Give first assignment name) -> Assign2 (Give second assignment name) -> Stop

Another Branch will go directly to Stop step.

In place on Assignment you need to execute the workflow. Its working as expected at my side.

Regards,

Jitesh Talreja