transformations:trimtable
no way to compare when less than two revisions
Differences
This shows you the differences between two versions of the page.
Previous revision | |||
— | transformations:trimtable [2023/10/05 00:33] (current) – 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===== | ||
+ | Keep only the top N significant items (e.g. top 10 products by sales volume) for a report or dashboard. | ||
+ | |||
+ | 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===== | ||
+ | **Example: | ||
+ | \\ | ||
+ | **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 | ||
+ | |||
+ | \\ | ||
+ | ====Community examples==== | ||
+ | * [[https:// | ||
+ | * [[https:// | ||
+ | * [[https:// | ||
+ | * [[https:// | ||
+ | |||
+ | \\ | ||
+ | =====See also===== | ||
+ | * [[transformations: | ||
+ | * [[transformations: | ||
transformations/trimtable.txt · Last modified: 2023/10/05 00:33 by dmitry