With this option, you can choose to evaluate the rule for the selected fields in the target assets section.
To select the fields that must be part of the custom rule:
- On the create rule page, click Select Fields.
- Use the search bar to perform a quick search for the required data assets.
- Use the available filters to find more specific results. The default value in the filters is set to any. The data can be sorted based on any parameter displayed in the columns.
- Proceed to select the required fields. Fields from multiple datasets can be
selected and added to the rule.Note: It is required to add fields of the same datatype for accurate rule evaluation.
- Upon selecting the initial field, the datatype associated with the selected
field is automatically updated and only those fields of the same datatype
are available for further selection. Note: The dataset that contains the first field would be selected as the reference dataset by default. This can be changed depending on the requirement.
- Click Add fields.
- This will add the selected fields to the target assets section.
- You can add more fields by clicking Select fields.
Tip: When modifying the selected fields, a new
datatype can be selected to view the fields associated with the new datatype.
When a new datatype is selected, the fields selected previously would still be a
part of the rule. Only when the fields of the new data type are selected, a
popup appears notifying that all the fields selected previously would be removed
and the filter would be reset. On clicking update, the newly selected fields
would be added to the rule.
Note: The fields added to the rule can be removed if they do
not serve the purpose of the rule. To remove the field, click the ‘-’
icon next to the associated field. When you try to delete a field that is part
of the reference dataset, a popup appears notifying the user that another
dataset would be marked as the reference dataset.
View and filter fields
When selecting the fields in the target assets section, you can apply filters and view the fields only for the selected parameters. The default value in the filters is set to Any. Click the filter type and a drop-down will appear with the available filter operators: Is, Is not, Is populated, Is not populated.
Filters available in the select fields section:
- Datasource type: Select the required datasource type to view only those fields or datasets associated with the specific datasource type.
- Datasource: Select the datasource to view the associated fields and datasets.
- Dataset: Select the respective datasets to view the fields associated with that dataset.
- Datatype: Select the required datatype to view only those fields of the associated datatype.
Each of the selected filters can be reset by clicking
the reset icon or all the selected filters can be reset by clicking Reset
Filters.
Datatypes supported in the
filter
Note: The filter operators are unavailable
for the datatype filter. By default, the "is" operator is applied when the
datatype filter is used.
| Datatype | Description |
|---|---|
| Boolean | Boolean datatype is intended to clarify conditional statements. It often has two values, either true or false. This lists only those fields that are of the boolean type. |
| Date | This data type is used to view those fields or datasets that signify a date. These are typically a combination of integers or numerical figures. |
| Datetime | This datatype is used to view fields that contain both date and time parts. |
| Decimal | This datatype is used to view those fields that contain values in decimals or floating points. |
| Integer | This datatype is used to view those fields that contain numerical values in the form of whole numbers. |
| String | Filters those data assets that is a combination of characters. These can include uppercase, lowercase letters, numbers and punctuation. |
| Time | Filters those data assets that hold values in the form of hours, minutes, seconds. |