SuccessFactors Integration center - Calculated Field

[ShipraPriydarshini]

Hello,

Would like to have some inputs for below logic to be incorporated in integration center for calculated field -

If 'employee id' is of 8 char length and first 3 chars are '400' then replace it with '000'

Else set ' Employee Id'

Then 'Prepend text' with ' 9876'

Somehow I am able to get right operation there - can I also use vlook table in this case but how.

Kindly suggest.

Many thanks.

Shipra P

[former_member22326]

Hi Shipra,

By what I know there's no easy fix for this if you want to fit all of this in 1 integration as with an IF statement you are bound to an exact match (unless you make a custom field that stores the first 3 characters somewhere in EC).

Would it be possible tor your customer to make 2 integrations of this (1 including employees with 400 as first 3 chars & one containing the remainder)? That way with a filter you could at least provide yourself a bit more flexibility to achieve this.
You could go for a calculated column and (granted its a string) do a replace all where 400 should set for "Remove all" and then do a prepend text with 000 and with the filter you could ensure it starts with 400 for the first integration
For the second integration you could even go for the latter (it may not even require a calculated field as with a regular field you can already add 1 simple calculation such as prepending text.