70+ configurable transformations

EasyMorph offers a wide range of transformations for designing calculations of virtually any complexity.
See below for examples of transformations in EasyMorph.
Scroll left or right to see more.

Lookup and replace

Replace values of a column with values from another table.

Aggregate

Calculate aggregates such as sum or count, grouped by one or more columns.

Append another table

Append another table as new rows or new columns.

Merge another table

Merge columns from another table where key columns match, using join or lookup mode.

Calculate column

Calculate new columns using formulas.

Deduplicate

Remove duplicate rows from a table.

Enumerate rows

Add new column with row numbers.

Fill down

Fill empty cells down with nearest non-empty value in the same column.

Filter

Remove or keep only rows with selected values in specified column.

Filter by condition

Keep only rows that satisfy condition (i.e. where expression is true).

Iterate

Iterate through a list of values passing them to another EasyMorph project and running the project.

Keep matching

Keep only rows with values that exist in another table.

Keep mismatching
Keep only rows with values that don't exist in another table.
Label columns

Make column names from one or more top rows.

Run program

Run external application. Command line arguments can be defined using an expression.

Remove columns

Remove one or more columns.

Rename columns

Rename one or more columns.

Rule

Multiple nested if/then/else conditions used to calculate a column.

Select columns

Keep only selected columns.

Sort

Sort table by one or more columns in ascending or descending order.

Table-wide replace

Remove or replace values in selected columns or entire table.

Trim table

Keep or remove given numbers of rows from the top or the bottom of table.

Trim table by condition

Keep or remove rows below or above first row that matches condition.

Unpivot

Turn matrix table into a straight table.

Supported database types and file formats

Import and merge data from databases, spreadsheets and files of various formats. Export at any point in a calculation. Below is our current list of supported database types and file formats:

Database Driver type (import & export)
Oracle ODBC / Native
SQL Server ODBC / Native
MySQL ODBC / Native
PostgreSQL ODBC / Native
SQLite ODBC / Native
Amazon Redshift ODBC only
DB2 ODBC only
Vertica ODBC only
Generic SQL:2003 dialect ODBC only

Note: the native drivers are built into EasyMorph and don't require installing anything else.

Source file formats Target file formats
Delimited text files (CSV, etc.) Delimited text files
Excel spreadsheets Excel (.xlsx only)
Tableau (.tde)
Qlik (.qvd) Qlik (.qvd)
XML files
SAS (.sas7bdat)

Native support for spreadsheets

Just as in Excel, in EasyMorph text and numbers can be mixed in the same column, which makes it a perfect tool for parsing spreadsheets with complex structures.

We've also designed a few special transformations to deal with cases common in spreadsheets, e.g. multi-line column headers or inconsistent sheet names.

Smart auto-calculation

When you change parameters or properties of a transformation EasyMorph smartly recalculates only transformations that are affected by the change. It can do this because, remember, it stores full results of all transformation steps in memory. Therefore it can keep results of unaffected transformations, and recalculates only affected ones. This eliminates the need to re-run everything from the beginning again and again. Meanwhile you can even keep working with the project as the recalculation takes place in the background, and is triggered automatically.

Built-in data visualization

Insert charts at any point of a calculation to get a better insight into the data. Drag column names into a chart to change chart categories and series on the fly.


Due to auto-calculation charts also update automatically when you modify, add or remove transformations.


Create simple PDF reports with charts and tables. Copy and paste charts into documents and presentations.

Advanced workflows

A number of special transformations allow creating advanced workflows:


  • Loops and iterations
  • IF/THEN and CASE/SWITCH workflows
  • Parameterized sub-routines
  • Inter-project calls and data exchange
  • Execution of external applications and Windows shell commands

Columnar In-Memory Engine

EasyMorph doesn't need an external database to run. It employs a proprietary in-memory columnar data transformation engine.


  • Data compression that helps store full intermediate results of all transformations in memory for instant access.
  • Automatic parallelization — independent branches of a calculation are executed asynchronously, e.g. reading a file and querying a database is typically done simultaneously.
  • The ability to run multiple projects on the same engine and pass calculation results between projects in memory.
  • Powerful non-relational transformations.

And more ...

Command-line mode
Run EasyMorph projects from the command line.
Integrate with other applications.
Scheduler
Schedule project execution when it's convenient for you.
Learn more.
Auto-Documentation
Generate documentation on transformation logic in plain English.
Here is an example.

You are 60 seconds away from trying EasyMorph.

Download