FILTER BY CONDITION

Category: Transform / Filters

This action calculates an expression for every row (without adding a new column) and keeps only rows where this expression is TRUE. All other rows are removed.

If no rows satisfy the condition then all rows are removed.

The expression must be a valid condition – it must return either TRUE or FALSE for any row in the table. If it results in a non-boolean value (i.e. not TRUE or FALSE) for at least one row it will cause a project execution error.

Create subsets of a dataset based on values across multiple columns.

Clean a dataset by removing records that don't meet certain criteria, or evaluate to a certain value.

Examples of valid conditions:

[Amount]=0
  
[Length] * [Width] * [Height] <= 1000
  
contains([City], 'York')
  
not isempty([Email])

[Date] >= #2024-02-01 and [Date] <= #2024-02-29

Example: Find all rivers that are longer than 6000 km.

Source table: The longest rivers in the world

Action parameters:

Expression: [Length (km)] > 6000

Result table:

• Compare two Excel sheets with EasyMorph (Project; Module: Main; Group: Main; Table: Result; Action position: 3)
• Create a new table with columns based on row values (Project; Module: Module 1; Group: Tab 1; Table: Table 1; Action position: 2)
• Update existing data in a database table (Project; Module: Main; Group: Tab 1; Table: Where clause; Action position: 2)
• Load only workbooks with given number of sheets (Project; Module: Main; Group: Tab 1; Table: Get file names to load;
  Action position: 5)
• Join 2 tables with multi criterions equal and not equals in where (Project; Module: Main; Group: Tab 1; Table: Join; Action position: 3)

• Filter
• Filter by search
• Filter by type
• Expressions: Expression syntax