transformations:filterminmax
no way to compare when less than two revisions
Differences
This shows you the differences between two versions of the page.
Next revision | |||
— | transformations:filterminmax [2018/08/15 08:44] – created dmitry | ||
---|---|---|---|
Line 1: | Line 1: | ||
+ | ===== 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: 2023/10/05 00:35 by dmitry