Create Process Expressions
Create Process Expressions

Create Process Expressions

image

Process expressions allow you to use data attributes presented in a source datastore in expressions to build transformations that map to your destination.

The syntax for the expressions and available functions are listed in detail in our section on Process Expressions Syntax.

image

To create a process expression, navigate to a process.

Highlight the process and select Edit Process

image

Select +Add Expression Column

image

Name the column that will be represented by an expression.

Enter the expression and click Save

image

The syntax of the expression will be checked.

image

The expression can be manually mapped (click on the expression and then the destination column).

image

Save the process.

icon
Run the process to check that the expression is successful — for example if your source data contains NULLS or empty strings you may need to handle that in the expression.
icon
A detailed guide to the expression editor syntax can be found in the pages on Process Expressions Syntax.

More options working with processes are in the following pages;