/
Formula

Formula

Description

The Formula step can calculate Formula Expressions within a data stream. It can be used to create simple calculations like [A]+[B] or more complex business logic with a lot of nested if / then logic.


When you press on the Formula cell entry, the formula editor window opens and gives you help on the available functions:


The formula editor window does a direct check on the syntax and the field names supplied. In case of an error you get the error message direct, for instance:

Related content

Process files
Read with this
Get File Names
Read with this
Simple evaluation (Job Entry)
Simple evaluation (Job Entry)
Read with this
Merge Join
Read with this
08. Functions and Expressions
08. Functions and Expressions
Read with this
Generate Random Value
Generate Random Value
Read with this