EasyMorph offers more than 70 transformations. While such variety enables a lot of flexibility, it can be confusing at first. The next few chapters describe a few frequently used transformations that can help you get started:
The most basic filtering transformation is Filter. It keeps (or removes) table rows with only selected values in particular column. The example below shows how Filter keeps only rows where [LFO Description] is 'All Establishments'.
Another frequently used filtering transformation is Filter by condition. It allows defining the filtering condition as a formula. The transformation keeps only table rows where the condition is true. In the example below only cities with names containing 'San' are kept.
Deduplicate transformation removes duplicate rows.
Trim transformation keeps or removes top N rows. It's equivalent to prefix FIRST in some SQL dialects.
Keep matching transformation keeps only rows with values that exist in another table.