transformations:keeptop
Differences
This shows you the differences between two versions of the page.
Both sides previous revisionPrevious revisionNext revision | Previous revisionNext revisionBoth sides next revision | ||
transformations:keeptop [2015/04/10 11:38] – elenap | transformations:keeptop [2015/05/01 08:58] – dmitry | ||
---|---|---|---|
Line 1: | Line 1: | ||
- | ===== Keep Top Rows ===== | + | ===== Trim Table ===== |
- | This transformation keeps only first N rows and removes all other rows. | + | This transformation keeps or removes |
- | + | ||
- | If you need to remove bottom rows -- add line numbers using [[transformations: | + | |
EXAMPLE | EXAMPLE | ||
- | **Source table:** The longest rivers in the world | + | **Source table:** The longest rivers in the world in descending order (by length) |
^ River ^ Length (km) ^ Continent | ^ River ^ Length (km) ^ Continent | ||
Line 20: | Line 18: | ||
- | **Objective: | + | **Objective: |
**Transformation parameters: | **Transformation parameters: | ||
+ | * Keep or Remove: Keep | ||
+ | * Top or bottom: Top | ||
* Number of rows: 3 | * Number of rows: 3 | ||
+ | |||
+ | **Output table:** | ||
^ River ^ Length (km) ^ Continent | ^ River ^ Length (km) ^ Continent |