DataFlux Data Management Studio 2.6: User Guide

Expression Builder

The Expression Builder enables you to use pre-built DataFlux expressions to create one or more checks for a business rule. The pre-built expressions are divided into four categories:

Compare Entire Field

Compare Portion of Field

Get Field Information

Compare Entire Field

Compare a field to a value or another field

Compare a field value to list of values

Compare a field to a field in a data source

Compare a field to a reference data domain

Determine if a field is inside or outside a range of values

Determine how a field differs (amount/percentage) from another field

Determine if a field matches a pattern or regular expression

Compare Portion Of Field

Compare a portion of a field to a value

Determine if a field begins with, ends with, or contains a value

Compare part of date field to a value

Get Field Information

Get information about the contents of a field

The following options are available: is/is not, null, alphabetic, alphanumerical, and control characters.

Check the case

The following options are available: is /is not lower, uppercase, and mixed case.

Compare the length of a field equal to

If the pre-built expressions do not fulfill your business needs, you can add custom metrics to a business rule.

Documentation Feedback: yourturn@sas.com
Note: Always include the Doc ID when providing documentation feedback.

Doc ID: dfU_BusRule_ExpressBuild.html