transformations:filterminmax
This is an old revision of the document!
Keep min/max
This action keeps (removes) only rows with values that are the biggest (smallest) in specified column.
Example
Table: Before
| Product | Price, USD |
|---|---|
| A | 12 |
| B | 16 |
| C | 14 |
| D | 13 |
| E | 13 |
| F | 9 |
Goal: obtain products with the lowest 3 prices.
Table: After
| Product | Price, USD |
|---|---|
| A | 12 |
| D | 13 |
| E | 13 |
| F | 9 |
transformations/filterminmax.1534337090.txt.gz · Last modified: 2018/08/15 08:44 by dmitry