TRIM TABLE BY CONDITION

Category: Transform / Filters

Description

This action removes the rows above or below the first row where the specific condition is true.

Remove records that occurred before or after a specific date.
Remove records of system events that happened before an error occurred, keeping the events that happened after the error.
Determine the effect of a sale by removing sales data prior to the sale and focusing on the post-sale data.
Remove rows after a specific situation occurs, keeping the steps that happened leading up to the situation.

Setting	Description
Condition	Enter an expression that evaluates to TRUE or FALSE.
Delete rows that are	Select whether the rows above or below the first match are removed. Options: Above first match or Below first match.
Delete first matching row too	When checked, the first row that satisfies the Condition is removed as well as the rows above/below it.

Remove the rows with Montreal sales.

Condition: [Store/City]="Total Montreal"
Delete rows that are: Above first match
Delete the first matching row too

Remove records after the system error occurred to focus on the steps that may have caused it.

Condition: [Log Message]="ERROR: Connection Lost"
Delete rows that are: Below first match

How to parse EDI file (e.g. X12 transaction set 837) (Project; Module: Main; Group: Header; Table: Raw header; Action position: 2)
How to parse EDI file (e.g. X12 transaction set 837) (Project; Module: Main; Group: Raw EDI; Table: Raw EDI X12; Action position: 5)
My first experiment API + conditional workflow + iteration (Project; Module: Main; Group: Acquisition data via API; Table: Data from API; Action position: 5)