Parameter Types 

Anchor
paramTypes paramTypes

When writing expressions, it is important to consider the type of the result. For example, you can it is possible write an expression to return the integer 3 but have defined for a stream attribute with the type of the stream attribute to be a string. If there is a mis-match between data types, when the expression is evaluated, PhixFlow stops evaluating the expression and reports an error.

The full list of types handled by PhixFlow is shown in the following table. 

Assigning a Literal Value to a Field

The most basic expression simply assigns a constant value to the field.

String Concatenation (+)

The + operator also serves as the string concatenation operator. This means you can use + to  join strings together. For example if in.customerName returns "Smith" and in.title returns "Mr":

Using Functions

PhixFlow has a set of functions you can use in expressions. Functions have a set of comma-separated arguments, enclosed in backets.; see Functions. Each function has a help page explaining it's syntax, which has the form

name (arg1, arg2...)syntax is usually <name ( argThese functions contain arguments, which may be one of the following:

• a simple integer or string
• another expression
• one of the Internal Variables
• Regular Expressions, to match patterns within strings or arrays.

The help page for each function explains what PhixFlow expects for a specific argument.

Expressions contain brackets that contain set of arguments. The arguments are separated by commas. Expressions can also include:

• a simple integer or string; Text Expressions and Escape Characters
• PhixFlow's Internal Variables
• your own user-defined variables, called $-variables; see Using Variables
• Regular Expressions, to match patterns within strings or arrays
• another expression
• Functions

see Functions. Each function has a help page explaining it's syntax,

Assigning Values to Variables

Anchor
dollarvar-intro dollarvar-intro

In PhixFlow, you can create your own variables using a $ symbol, for example $variableName; see Using Variables.

Assigning Values From a Pipe 

Anchor
pipe pipe

Stream attribute expressions are commonly used to fetch the value returned by a Pipe. This is simply done by suffixing the pipe name with the name of the attribute to be returned. For example: 

  in.accountRef

This expression causes PhixFlow to look at the pipe named "in" and return the value in the field called "accountRef".

Calculating an Attribute Name

If the name of the attribute whose value you want has to be calculated based on other factors, you can assign the attribute name to a $-variable. You then use the variable instead of the attribute name itself. For example:

  in.$attrName

Handling Invalid Characters

There are two options for handling an attribute name that contains invalid characters.

• Either assign that name to a variable and use the variable instead of the actual attribute.
• Or enclose the name in quotes, for example:  in.'account-ref'.

Mathematical Operators (+, -, *, /)

Several values can be combined using the usual basic mathematical operators. For example when in.numProducts has the value 9:

The usual calculation precedences apply, so * and / operations are carried out before + and -. When the mathematical statements involve multiple calculations, use brackets ( ) to force the correct processing order.

String Concatenation (+)

The + operator also serves as the string concatenation operator. This means you can use + to  join strings together. For example if in.customerName returns "Smith" and in.title returns "Mr":

If you use + to concatenate a string and a number (integer or floating point), then PhixFlow treats the number as if it is a string. For example:

Adding Comments

It is always a good idea to add comments to your scripts to explain its steps. Comments help anyone who needs to modify the script in future.

There are two ways to tell PhixFlow that a line is a comment, and can be ignored.

For some examples of using comments, plus other style tips for expressions, see Expression Style.

Using Functions

PhixFlow has a set of functions you can use in expressions; see Functions. These functions contain arguments, which may be one of the following:

• a simple integer or string
• another expression
• one of the Internal Variables
• Regular Expressions, to match patterns within strings or arrays.

The help page for each function explains what PhixFlow expects for a specific argument.

If() Function

It is common to want to evaluate whether or not data meets a condition. To do this use the if() function in an expression. This function has 3 arguments.

if(
    //argument 1 - the condition
   _out.AppleHarvestDate < _toDate('20210101'),

    //argument 2 - return this if true
    1,

    //argument 3 - return this if false
    0

)

In this expression, the first argument is the condition, which is also an expression. This selects records that have a date before 1st January 2021. The remaining arguments are simple integers - for records that:

• meet the condition, PhixFlow returns 1 to indicate true.
• do not meet the condition, PhixFlow returns 0 to indicate false.

Alternatively, the expression could return strings, which must be enclosed in quote marks.

if(
   _out.AppleHarvestDate < _toDate('20210101'),
    "true",
    "false"
)

Multiline Statements and $-variables

Anchor
dollarVar dollarVar

When you are working with more complex expression, you may have several different statements to evaluate first. To group statements together, use the do() function.

In multi-line statements, you usually need to assign the value of an expression to a $-variable, to use later in the expression. For example:

The value of an expression that is used, is the value of the last statement to be evaluated. In simple expressions, such as the example above, the last statement to be evaluated is the last line. However, in Conditional Statements, the last statement evaluated is not always the last statement in the expression. For example:

See Also

• Expressions and Scripts topic page for links to more information.