Skip to Content
May 14, 2013 at 07:35 PM

Mapping the source fields based on condition


Hi Guru's,

I need to map one filed based on some condition.

Suppose my source value for the 'field1' is abc-123 then I need to remove all the content before '-' and then map the rest of the content i.e 123.

Is this possible using graphical mapping (pls provide the screen shot), or do I need to write UDF, If yes pls provide example.

Input for field F1 Output should be

abc-123 123

xyz-456 456

pqr789 pqr789

123-ijk ijk

Appreciate your help