Working With Operations

The Operation is a single action that allows you to customize the way you view data.

For example, the Uppercase operation turns all data in the selected column into Uppercase characters.

Each operation updates data for a selected column in a certain way defined by options (for example, inputs, values, radio buttons, check boxes, and so on) which are set in corresponding XML files and help to distinguish and update data, as shown in the following image.

For example, the Cleanse SSN operation contains the following options:

1. Format. Indicates what format of data should appear after an operation is applied (nine digits will be displayed in a specified way).
2. Remove invalid values? Select this check box if you want to remove data that does not satisfy a specified format (less or more than nine digits, characters, or special symbols).
3. Tags. Added to data and characterizes it according to the set tag value.

The operation content corresponds to the column data type you select. You can set the parameters for any operation you choose. You can edit the following parameter types:

1. Behaviour parameters. What the operation has to execute.
2. Tags. Signs off the execution of an operation.
3. Output format. A set of possible output format options for the content type.

There are two ways to add an operation: add as quick operation from the table context menu and add from the rule. The Add Quick Operation is shown in the following image.

There are also two types of operations depending on the affected areas: Simple and Multicolumn.

Simple operations are related to one Attribute and after execution of the rule will affect data only for the selected attribute.

Mulitcolumn operations involve several attributes and work with data from those attributes that are listed in the inputs and outputs of the operations, as shown in the following image.

The rule that contains a mulitcolumn operation will be created for each involved attribute, as shown in the following image.

You can hover your cursor over the operation and see the name, parameters, and tags inside the corresponding tooltip, as shown in the following image.

You can edit and delete any operation, as shown in the following image.

Only one operation at a time can be opened in Edit mode. If you try to open another operation or do another action while the operation is opened, you will be asked to save changes first, as shown in the following image.