Skip to Content
0
Former Member
May 27, 2010 at 05:55 PM

Else if mapping

36 Views

Hi All,

I have a field at source side as CREATED_BY which is need to map to CREATED at target side. I need the solution for below logic

if first 2 letters of CREATED_BY is AM

then CREATED = Telus

elseif first 2 letters of CREATED_BY is LV

then CREATED = TELUS US

elseif first 2 letters of CREATED_BY is MO

then CREATED = Concentrix.

if none of this condition is met the map with default value which is Telus.

Can anyone suggest me should I go for UDF or I can achieve the functionality by standard functions provide by message mapping. If it can be achieved by standard function then please provide complete the solution. Your help is highly appreciated

how to create UDF for above logic?

Regards

Faisal

Edited by: Abdul Faisal on May 27, 2010 11:26 PM