The following table lists and describes conditionals in iWay DQS.
Conditional |
Description |
---|---|
if(ifExpr, trueExpr, elseExpr) |
Returns trueExpr if ifExpr is TRUE. |
case(expr, exprValue[, expr, exprValue]...[, defaultExpr]) |
Returns the value of expression exprValue immediately following the first expression expr whose value is TRUE. |
decode(decodeExpr, expr, exprValue[, expr , exprValue]...[, defaultExpr]) |
Returns the value of expression exprValue immediately following the first expression expr whose value is equal to decodeExpr. |
nvl(expr[, expr]...) |
Returns the value of the first expression expr whose value is not NULL. |
iWay Software |