TRIM TABLE

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.

Remove the 2 rows of metadata (heading and underline) from the top of the table.

Keep only/Remove: Remove
Top/Bottom: Top
N rows: 2

Keep the top 3 rows of the table and remove the rest.

Keep only/Remove: Keep
Top/Bottom: Bottom
N rows: 3

• 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