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/05/01 12:55] – elenap | transformations:keeptop [2021/07/18 23:43] – craigt | ||
---|---|---|---|
Line 1: | Line 1: | ||
- | ===== Trim Table ===== | + | {{ transformations: |
+ | ====== | ||
+ | Category: Transform / Filters\\ | ||
- | This transformation | + | \\ |
+ | =====Description===== | ||
+ | This action | ||
- | EXAMPLE | + | \\ |
+ | =====Use cases===== | ||
+ | Keep only the top N significant items (e.g. top 10 products by sales volume) for a report or dashboard. | ||
- | **Table:** The longest rivers in the world in descending order (by length) | + | Reduce |
- | ^ River ^ Length (km) ^ Continent | + | Remove extraneous metadata from the top or bottom of a dataset.\\ |
- | | Nile | 6650 | Africa | + | |
- | | Amazon | + | |
- | | Yangtze | + | |
- | | Mississippi | + | |
- | | Yenisei | + | |
- | | Yellow River | 5464 | Asia | | + | |
- | | Ob | 5410 | Asia | | + | |
- | | Paraná | + | |
+ | \\ | ||
+ | =====Action settings===== | ||
+ | ^Setting ^Description ^ | ||
+ | |Keep only/ | ||
+ | |Top/ | ||
+ | |N rows< | ||
+ | < | ||
- | **Objective: | + | \\ |
+ | =====Examples===== | ||
+ | **Objective: | ||
+ | \\ | ||
+ | **Table:** The longest rivers in the world (in descending order by length) | ||
+ | ^River | ||
+ | | Nile | 6650|Africa | ||
+ | | Amazon | ||
+ | | Yangtze | ||
+ | | Mississippi | ||
+ | | Yenisei | ||
+ | | Yellow River | 5464|Asia | ||
+ | | Ob | 5410|Asia | ||
+ | | Paraná | ||
+ | \\ | ||
+ | **Action parameters: | ||
+ | > Keep or Remove is " | ||
+ | > Top or Bottom is " | ||
+ | > Number of rows is " | ||
+ | \\ | ||
+ | **Result table:** | ||
+ | ^River | ||
+ | | Nile | 6650|Africa | ||
+ | | Amazon | ||
+ | | Yangtze | ||
- | **Transformation parameters:** | + | \\ |
- | * Keep or Remove: Keep | + | ====Community examples==== |
- | * Top or bottom: Top | + | |
- | * Number of rows: 3 | + | * [[https:// |
+ | * [[https:// | ||
+ | * [[https:// | ||
- | **Result:** | + | \\ |
+ | =====See also===== | ||
+ | | ||
+ | | ||
- | ^ River ^ Length (km) ^ Continent | ||
- | | Nile | 6650 | Africa | ||
- | | Amazon | ||
- | | Yangtze |