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.
Replace values of a column with values from another table.
Calculate aggregates such as sum or count, grouped by one or more columns.
Append another table as new rows or new columns.
Merge columns from another table where key columns match, using join or lookup mode.
Calculate new columns using formulas.
Remove duplicate rows from a table.
Add new column with row numbers.
Fill empty cells down with nearest non-empty value in the same column.
Remove or keep only rows with selected values in specified column.
Keep only rows that satisfy condition (i.e. where expression is true).
Iterate through a list of values passing them to another EasyMorph project and running the project.
Keep only rows with values that exist in another table.
Make column names from one or more top rows.
Run external application. Command line arguments can be defined using an expression.
Remove one or more columns.
Rename one or more columns.
Multiple nested if/then/else conditions used to calculate a column.
Keep only selected columns.
Sort table by one or more columns in ascending or descending order.
Remove or replace values in selected columns or entire table.
Keep or remove given numbers of rows from the top or the bottom of table.
Keep or remove rows below or above first row that matches condition.
Turn matrix table into a straight table.
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|
|SAP HANA||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)|
|Qlik (.qvd)||Qlik (.qvd)|
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.
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.
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.
A number of special transformations allow creating advanced workflows:
EasyMorph doesn't need an external database to run. It employs a proprietary in-memory columnar data transformation engine.