Conditional statements in the Reformat component

CloverDX Platform
1

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

2

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.