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
- The following operations are available for both
numeric and text types <, > =<, =>, =, and !=. For text types,
an alphabetical comparison is performed.
- Text comparison with the ability to perform trim,
case sensitivity, and wild cards is available.
Compare a field value to list of values
- The following options are available: = and !=.
- You can import values from a table or from
a formatted text file (one entry per line).
- Text comparison with the ability to perform trim,
case sensitivity, and wild cards is available.
Compare a field to a field in a data source
- Checks to see if the field matches or does not match the value of a field in a data source (data source type).
Compare a field to a reference data domain
- Checks to see if the field value matches or does not match a value in Reference Data Management domain. Reference Data Management is a Web Studio module. The check works only with Reference Data Management domains of type
List.
Determine if a field is inside or outside a range of
values
- The operators are inside or outside a set.
- Text comparison with the ability to perform trim,
case sensitivity, and wild cards is available.
Determine how a field differs (amount/percentage) from
another field
- The following operations are available for both
numeric and text types <, > =<, =>, =, and !=.
- For text types, it performs an alphabetical comparison.
- The difference can be an amount or percentage.
Determine if a field matches a pattern or regular expression
- The operators include match and does not match.
- Regular expressions are available for comparison.
Compare Portion Of Field
Compare a portion of a field to a value
- The following portions are available: leftmost,
rightmost, character X to character Y (X, Y are numbers), and character
X through the end (X is a number).
- The following operations are available for both
numeric and text types <, > =<, =>, =, and !=. For text types,
it performs an alphabetical comparison.
- Text comparison with the ability to perform trim,
case sensitivity, and wild cards is available.
Determine if a field begins with, ends with, or contains
a value
- The following options are available: begins with,
ends with, contains, and does not contain.
- The case sensitivity can be determined.
Compare part of date field to a value
- The following date parts are available: month,
day, year, hour, minute, and second.
- The following options are available for both numeric
and text types <, > =<, =>, =, and !=.
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
- The following operators are available: <, >
=<, =>, =, and !=.
- You can combine these built-in checks using
AND/OR logic.
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
|