FILTER BY CONDITION

Category: Transform / Filters

This action calculates an expression for every row 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.

• 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.
  

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.

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

Find all mountains that are taller than 8600 m.

Expression: [Height (m)] > 8600

• 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