User Tools

Site Tools


transformations:filterminmax

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

transformations:filterminmax [2018/08/15 12:44] (current)
dmitry created
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: 2018/08/15 12:44 by dmitry