User Tools

Site Tools


transformations:keeptop

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/RemoveSelect whether N number of rows will be kept or removed.
Top/BottomSelect whether the rows at the top or bottom of the table will be kept/removed.
N rows*Enter/Select the number of rows to keep/remove.

* Setting can be specified using a 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 6650Africa
Amazon 6400South America
Yangtze 6300Asia
Mississippi 6275North America
Yenisei 5539Asia
Yellow River 5464Asia
Ob 5410Asia
Paraná 4880South America


Action parameters:

Keep or Remove is "Keep"
Top or Bottom is "Top"
Number of rows is "3"


Result:

River Length (km) Continent
Nile 6650Africa
Amazon 6400South America
Yangtze 6300Asia


See also

transformations/keeptop.txt · Last modified: 2021/05/04 17:46 by craigt