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.