Pliable allows you to define rules to determine which records come through from your data source. You can set up filters in the Data Cleaning Wizard.
On the top right of your selected column, click on Filter. This will open the Edit Filters screen which allow you to add different conditions to columns.
| Condition | Description |
|---|---|
| is equal to | Matches rows where the column value is exactly equal to the specified value. |
| is not equal to | Matches rows where the column value is not equal to the specified value. |
| contains | Matches rows where the column value contains the specified substring. |
| does not contain | Matches rows where the column value does not contain the specified substring. |
| is greater than | Matches rows where the column value is greater than the specified value. |
| is greater than or equal to | Matches rows where the column value is greater than or equal to the specified value. |
| is less than | Matches rows where the column value is less than the specified value. |
| is less than or equal to | Matches rows where the column value is less than or equal to the specified value. |
| is blank | Matches rows where the column value is blank (null or empty). |
| is not blank | Matches rows where the column value is not blank (contains a value). |
| starts with | Matches rows where the column value starts with the specified substring. |
| does not start with | Matches rows where the column value does not start with the specified substring. |
| ends with | Matches rows where the column value ends with the specified substring. |
| does not end with | Matches rows where the column value does not end with the specified substring. |
| is a valid date | Matches rows where the column value is a valid date. |
| is not a valid date | Matches rows where the column value is not a valid date. |
| is a valid number | Matches rows where the column value is a valid number. |
| is not a valid number | Matches rows where the column value is not a valid number. |
If you click Add Condition, you can select a new column and condition. If you want to only allow records that match all of the conditions, keep Match ALL on, otherwise click to Match ANY .
After adding your conditions, click on Test Filters to display the resulting filtered data.