Overview

An expression is any mathematical expression, that when evaluated will produce a single value. Expressions may work on numbers, text, dates or any other Eightwire data type.

For example, a simple expression to perform basic arithmetic could be:

(3 * 2) + 7

This would result in the destination column containing the numeric value 13 for each row.

Similarly, functions may be used to manipulate data, such as this one, to give just the first part of a multi-part term:

FirstToken(“the quick brown fox”)

This would result in the destination column containing the text value ‘the’.

Lastly, system metadata and data from the source table may also be included. This example combines the System Batch ID with the value in the source Key column:

System(“Batch.ID”) + Data(“Key”)

This would result in the destination column containing a different value for each row, something like “1055737Jane”, “1055737Bob”, “1055737Mel”, etc.

The following pages show the operators and functions available when using Process Expressions;