User Tools

Site Tools


transformations:filterminmax

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.txt · Last modified: 2018/08/15 12:44 by dmitry