Page tree

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: Published by Scroll Versions from space DEV and version next

D toc

Excerpt

In your recipe steps, you can apply conditional logic to determine if transformational changes should occur. 

You can build logical tests into your transformations in multiple levels:

...

You can use the IF function in any transformation that accepts functional inputs. For more information, see IF Function.

CASE function

You can chain together IF functions in the following manner:

...

D trans
Typestep
p01NameColumns
p01ValuetestCol
p02NameFormula
p02ValueCASE([ $col >= 0.75, 'IN', $col >= 0.35, 'MAYBE IN', 'OUT'])
SearchTermEdit column with formula

 

If testTestOutput if true
If:$col >= 0.75IN
If above is false:$col >= 0.35
MAYBE IN
If above is false:defaultOUT

For more information, see CASE Function.

Logical Operators

Logical operators can be applied to your function expressions to expand the range of your logical tests.

...

Depending on the structure of your transformation and your preferences, either form may be used.

...

D s also
inCQLtrue
label(label = "logic")