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