I have two questions regarding the 'if' condition in the Reformat component:
1. How would I perform a null check on a field (and if it is null, then assign another field to it)?
2. How would I perform a check if a field has a specific value (e.g "N"), then assign the value of another field?
Thanks,
- CB
1. How would I perform a null check on a field (and if it is null, then assign another field to it)?
2. How would I perform a check if a field has a specific value (e.g "N"), then assign the value of another field?
Thanks,
- CB
-
Hello,
for if syntax in CTL see Selection statements. Mapping in CTL has to be as a last statement only, so for assigning some values due to condition you have to create your own CTL function (see If condition in A GRAPH). For checking null values use isnull or nvl function.
Please sign in to leave a comment.
Comments 1