Creating Rules

You can create rules with the Measure Factory Editor.

On the upper right of the Rules page, click New.

Measure Factory editor Rules page showing the location of the New option.

The New Rule Closeddialog box opens in the right pane of the Rules page.

New Rule dialog box.

Select a data set and a type of rule, and then select Create rule.

I want to...

Type of rule to create

Icon

Apply metadata to a column from the source data

NOTE: In Workbench 7.1(13) and later, DI recommends that you either allow automatic import of all input columns or use setup rules instead of source rules.

Source rule

Source Rule Icon

Select specific columns to pull in from the source input.

NOTE: In Workbench 7.1(13) and later, DI recommends that you use setup rules instead of source rules.

Setup rule Setup Data Rule Icon or Setup Plugin Rule Icon

Process an expression that returns a value of any Spectre data type

Calc rule

Calc Rule Icon

Associate a single value from the source data with values defined in a lookup table

Lookup rule

Lookup Rule Icon

Associate one or more values from the source data with values defined in a flag table

Flag rule

Flag Rule Icon

Move values from one data set to another

Link rule

Link Rule Icon

Perform an action other than the ones described above

Plugin rule

Plugin Rule Icon

For more information, see Measure Factory Rule Types.