transformations:keeptop
Differences
This shows you the differences between two versions of the page.
Both sides previous revisionPrevious revisionNext revision | Previous revision | ||
transformations:keeptop [2021/05/04 17:46] – craigt | transformations:keeptop [2023/10/05 00:34] (current) – removed dmitry | ||
---|---|---|---|
Line 1: | Line 1: | ||
- | {{ transformations: | ||
- | ====== TRIM TABLE ====== | ||
- | Category: Transform / Filters\\ | ||
- | |||
- | \\ | ||
- | =====Description===== | ||
- | This action keeps or removes the first or last N rows.\\ | ||
- | |||
- | \\ | ||
- | =====Use cases===== | ||
- | Reduce the size of a larger dataset to a specific number of rows during the initial build of a workflow. | ||
- | |||
- | Remove extraneous metadata from the top or bottom of a dataset.\\ | ||
- | |||
- | |||
- | \\ | ||
- | =====Action settings===== | ||
- | ^Setting ^Description ^ | ||
- | |Keep only/ | ||
- | |Top/ | ||
- | |N rows< | ||
- | < | ||
- | |||
- | \\ | ||
- | =====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:** | ||
- | ^River | ||
- | | Nile | 6650|Africa | ||
- | | Amazon | ||
- | | Yangtze | ||
- | |||
- | \\ | ||
- | =====See also===== | ||
- | * [[transformations: | ||