transformations:trimtable
no way to compare when less than two revisions
Differences
This shows you the differences between two versions of the page.
Last revision | |||
— | transformations:trimtable [2015/04/17 09:01] – created dmitry | ||
---|---|---|---|
Line 1: | Line 1: | ||
+ | ===== Trim Table ===== | ||
+ | This transformation keeps only or removes first or last N rows of a table. It's suitable for showing top N results or removing bottom row with total numbers. | ||
+ | |||
+ | EXAMPLE | ||
+ | |||
+ | **Source table:** The longest rivers in the world | ||
+ | |||
+ | ^ River ^ Length (km) ^ Continent | ||
+ | | Nile | 6650 | Africa | ||
+ | | Amazon | ||
+ | | Yangtze | ||
+ | | Mississippi | ||
+ | | Yenisei | ||
+ | | Yellow River | 5464 | Asia | | ||
+ | | Ob | 5410 | Asia | | ||
+ | | Paraná | ||
+ | |||
+ | |||
+ | **Objective: | ||
+ | |||
+ | **Trim mode** | ||
+ | * Keep only top rows | ||
+ | |||
+ | |||
+ | **Transformation parameters: | ||
+ | * Number of rows: 3 | ||
+ | |||
+ | **Output table:** | ||
+ | |||
+ | ^ River ^ Length (km) ^ Continent | ||
+ | | Nile | 6650 | Africa | ||
+ | | Amazon | ||
+ | | Yangtze |
transformations/trimtable.txt · Last modified: 2023/10/05 00:33 by dmitry