Differences

This shows you the differences between two versions of the page.

--- transformations:keeptop [2021/05/04 17:46] – craigt
+++ transformations:keeptop [2023/10/05 00:34] (current) – removed dmitry
@@ Line 1: / Line 1: @@
-{{ transformations:TrimTableAction.png}}
-====== 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 the //Trim table// action when the workflow is complete, to process the entire dataset.
-Remove extraneous metadata from the top or bottom of a dataset.\\
-\\
-=====Action settings=====
-^Setting ^Description ^
-|Keep only/Remove|Select whether N number of rows will be kept or removed.|
-|Top/Bottom|Select whether the rows at the top or bottom of the table will be kept/removed.|
-|N rows<sup>*</sup>|Enter/Select the number of rows to keep/remove.|
-<sup>*</sup> Setting can be specified using a [[:parameters|parameter]].
-\\
-=====Examples=====
-**Objective:** Keep the top three longest rivers.\\
-\\
-**Table:** The longest rivers in the world (in descending order by length)
-^River  ^Length (km)  ^Continent  ^
-| Nile  |  6650|Africa  |
-| Amazon  |  6400|South America  |
-| Yangtze  |  6300|Asia  |
-| Mississippi  |  6275|North America  |
-| Yenisei  |  5539|Asia  |
-| Yellow River  |  5464|Asia  |
-| Ob  |  5410|Asia  |
-| Paraná  |  4880|South America  |
-\\
-**Action parameters:**
-> Keep or Remove is "Keep"
-> Top or Bottom is "Top"
-> Number of rows is "3"
-\\
-**Result:**
-^River  ^Length (km)  ^Continent  ^
-| Nile  |  6650|Africa  |
-| Amazon  |  6400|South America  |
-| Yangtze  |  6300|Asia  |
-\\
-=====See also=====
-  * [[transformations:keepremovematching|Keep/remove matching]]