Skip to Content
0
May 19, 2010 at 03:04 AM

Mapping Help

18 Views

Hi..

I am trying to do a mapping. I have two incoming fields where in based on two conditions I need to get different results at the output.

If there are values in both the fields then I need to merge the two strings

If one of the values is blank then I need to add constant (for ex abc ) after the string and send it to the output.

I am trying to do this using standard functions. How can I check if the field has a value in it or no ..Or have I do go for an UDF. If a UDF is needed can some one help me with the same.