Skip to main content

NIM

Expression item

In Filters, an Expression filter item excludes rows from the output table by filtering on values in a specified column, according to a chosen logical operator.

Unlike Relation items, expression items never add rows or columns to the output table. Expression items are not join operations. They can only produce an output with the same or fewer number of rows, and the same columns.

Tip

Logical operators in expression items cannot reference data in other tables. However, Lookups are a potential workaround. They are akin to expression items with an "exists in target column" logical operator.

ExpressionItems01.png

Expression items can take constant values or Parameters.

The following logical operators are available:

Contains (ci)

Case-insensitive whole string or substring match.

Not Contains (ci)

Inverts the results of Contains (ci).

Equals (ci)

Case-insensitive whole string match.

Not Equals (ci)

Inverts the results of Equals (ci).

Equals

Case-sensitive whole string match.

Not Equals

Inverts the results of Equals.

Exists

Includes all rows that have non-empty values for this column.

Not Exists

Inverts the results of Exists.

In

Comma separated list of multiple string values required for record(s) to return.

Not In

Inverse of In. Comma separated list of string that if they are found the record is not returned.

Regex

Regex pattern match. Supports flags. For example: /[ab]/i

Matches

Similar to Regex, but does not support flags. For example: [ab]

Not Matches

Inverse of matches. Similar to Regex, but does not support flags. For example: [ab]

Starts-With (ci)

Similar to Contains (ci), but only match starting at position 0.

Not Starts-With (ci)

Similar to Contains (ci), but only match starting at position 0. Case insensitive

Starts-With (cs)

Similar to Starts-With (ci), but case sensitive.

Not starts with (cs)

Inverse of Starts with (cs). Similar to Contains (ci), but only match starting at position 0. Case sensitive.