EasyMorph is a data manipulation tool that helps transform and analyze data quickly in a visual way. You can design data transformations with EasyMorph faster, compared to writing scripts in manual scripting languages.
Key Features include:
- Command line mode Run EasyMorph projects from the command line. Integrate EasyMorph with enterprise ETL tools and other applications.
- Auto documentation EasyMorph automatically generates a readable formatted description of all transformation logic in plain English.
- Import and Export EasyMorph lets you merge data from various sources. Export transformation results, if needed. The current list of supported data sources includes Native DB access, Oracle, SQL Server,MySQL and SQLite.
- 30+ transformations You don't have to have programming or SQL skills as EasyMorph offers 30+ built-in transformations which allow designing a transformation logic of almost any complexity.
EasyMorph allows you to transform data visually, unlike SQL, Visual Basic, Python, SAS, or Qlik. It does this by applying filter or join operations to data, step by step. EasyMorph stores all intermediate calculation results, so at any moment you can click any transformation step and instantly see the result.
EasyMorph has an intuitive interface that can easily be navigated by users of all levels of expertise. Just the same as in spreadsheets, text and numbers can be mixed in the same column. Simultaneously EasyMorph operates like a database, where tables can be filtered, merged (joined) and aggregated correctly even if table size changes. These features allow for robust, transparent and error-proof spreadsheet data processing with zero chance of errors.
Overall, designing data transformations with EasyMorph is a great tool to use as it's much faster and easier, compared to writing scripts and macros.
New actions: Remove empty columns, Sanitize, Total/Subtotal, Keep min/max, Cross Merge.
New functions: monthstart, monthend, weekstart, weekend, yearday, isoweeknumber.
Desktop: Automated data quality suggestions.
Quick export to file.
Error cards for call/iteration errors.