Category: Transform / Filters

This action keeps or removes the first or last N rows.

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 or disable 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.

^* Setting can be specified using a parameter.

Example: Keep the top three longest rivers.

Table: The longest rivers in the world (in descending order by length)

Action parameters:

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

Result table:

• A way to obtain all positions of a char in text (Project; Module: Main; Group: Tab 1; Table: Table 2; Action position: 3)
• Send email - Add table extract to outlook email message (Project; Module: Main; Group: Tab 1; Table: Input dataset with prepended headers row; Action position: 2)
• Read Data with two line header (Project; Module: Main; Group: Tab 1; Table: Read, Mark groups; Action position: 2)
• Transform parsed JSON to right format (Project; Module: Main; Group: Group 1; Table: Imported table 1.dset; Action position: 4)

• Keep/remove matching
• Trim table by condition