This brick is used to create a new dataset containing a subset of the input dataset's rows based on the provided set of rules.
Bricks → Data Manipulation → Filter Rows
- Combine rule as
There are two options for this parametr OR and AND. If you choose OR option it means that some subset of provided set of rules will be omitted, with AND option all set of rulse will be applied.
This parameter helps you to specify rules for filtering rows, there are three parameters: column, operator, value. For column you need to choose column to apply set of rules, operator values could be: '<','>','>=','<=', '==' ; and value you need to specify value to compare data with.
Brick takes the dataset.
New dataset with same or less number of rows
Suppose we have dataset about house prices. It consists of many columns, they are: id, Neighbourhood, YearBuilt, RoofMatl, GrLivArea, YrSold, SalePrice.
Then we connect Filter Rows brick, then you can select as many rules for filtering in one single brick as you want by clicking on '+' button in the brick settings. You'll have a filtered rows with the same columns as an output. We will use rules presented below:
The result is: