Skip to main content

Create Process Expressions

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.

To create a process expression, navigate to a process.

Highlight the process and select Edit Process

Processes in Presentation for Analytics list with the Edit Process tooltip over the pencil button on the AA_Inputs.xlsx row

Select +Add Expression Column

Editing Process Mapping panel for StagingIn.AcuteAdmissionsProcessCommon with the +Add Expression Column button highlighted

Name the column that will be represented by an expression.

Enter the expression and click Save

Expression dialog with Field Name ArrivalMonth, expression Datepart(Data("ArrivalDatetime"),"Month") and the Save button

The syntax of the expression will be checked.

Success toasts reading Expression checking has been successful and Manual mapping has been created successfully

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

Mapping panel with ArrivalMonth and ArrivalYear expression columns mapped to the ArrivalMonth and ArrivalYear NUMBER destinations

Save the process.

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.

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;

Stuck on this step? Email support@eight-wire.com