Filter

The Filter transformer as the name suggests allows you to filter records from the dataset with a simple visual interface.

Filter Transform dialog is shown as below:

1. Enter Title like most of the other transforms. Ensure that the Title is uniquely identifying the step
2. Enter Description to provide further information for this particular step. This is helpful in ensuring the transform step is readable in a complex workflow, ensuring readability. This step however, is Optional.
3. Add Filter. This option is used to add as many as filter user wants to have.
4. Select Column. This field is used to select the column name from which the user wants to filter the table.
5. Select Operator.This field allows the user to select multiple filter options.We support filters different datatypes like numerical,categorical and datetime.
6. Right Value(s). This field is works on filtering based on row values . we support one value for each filter.
7. delete Icon. This icon can be used to delete the filter created .
8. Click Create to add the step to the recipe.

For any categorical variables we support :

1. Is not empty
2. Is empty
3. is in
4. equals
5. is not equal to
6. starts with
7. ends with
8. contains

For any numerical variables we support :

1. is not empty
2. is empty
3. is between
4. equals
5. is not equal to
6. is greater than
7. is greater than or equals
8. is lesser than
9. is lesser than or equals

For Datetime variables we support:

1. is not empty
2. is empty
3. equals
4. is after
5. is between
6. is before
7. last N minutes
8. last N hours
9. last N days
10. last N years

A filled step would look like the one below: