overview
Differences
This shows you the differences between two versions of the page.
Both sides previous revisionPrevious revisionNext revision | Previous revisionNext revisionBoth sides next revision | ||
overview [2015/01/31 15:06] – [Derived tables] dmitry | overview [2018/05/09 19:37] – [Transformations] dmitry | ||
---|---|---|---|
Line 2: | Line 2: | ||
==== Data Import ==== | ==== Data Import ==== | ||
- | In order to start transforming data in EasyMorph, all data subject to manipulations has to be imported into EasyMorph as tables. | + | In order to start transforming data in EasyMorph, all data subject to manipulations has to be imported into EasyMorph as tables. |
+ | * Relational databases (Oracle, MS SQL Server, MySQL, PostgreSQL, SQLite) | ||
+ | * ODBC data sources (Oracle, MS SQL Server, MySQL, PostgreSQL, SQLite, Amazon Redshift, Vertica, SAP HANA, Apache Hive) | ||
* Text files with delimiters (e.g. CSV) | * Text files with delimiters (e.g. CSV) | ||
- | * Excel files (.xlsx | + | |
- | * QlikView' | + | |
+ | * Qlik data files (.qvd) | ||
+ | * SAS files (.sas7bdat) | ||
+ | * SPSS/PSPP files (.sav) | ||
- | One imported file creates one table. | + | Once tables are loaded into EasyMorph they can further be modified using transformations |
- | Technically speaking, import | + | Import |
- | ==== Transformations ==== | + | Databases can be queries using the Query Editor. |
- | All manipulations with tables are done with the help of various transformations. E.g. renaming a column is a transformation. Filtering, joining, aggregations -- all are transformations. Every transformation is an action that somehow changes table. | + | |
- | Transformations are executed consequently, | + | Files can be loaded |
+ | ==== Actions ==== | ||
+ | All manipulations with tables are done with the help of various actions. E.g. renaming a column | ||
- | Final state (or result) of a table is the result of all transformations of this table applied consequently, | + | * Create -- actions that create |
+ | * Import -- actions that import data into EasyMorph | ||
+ | * Transform -- actions that transform previously loaded data | ||
+ | * Export -- actions that export data into files and databases | ||
+ | * Workflow -- actions that help organize project workflow and perform various automation | ||
- | Some transformations (e.g. [[transformations: | + | Actions are executed consequently, |
- | Here is full list of all [[transformations: | + | Final state (or result) of a table is the result of all actions of this table applied consequently, |
+ | |||
+ | Some actions (e.g. [[transformations: | ||
+ | |||
+ | Here is full list of all [[transformations: | ||
==== Expressions ==== | ==== Expressions ==== | ||
Line 26: | Line 40: | ||
==== Derived tables ==== | ==== Derived tables ==== | ||
- | Derived tables is a powerful feature that allows transforming data in a non-linear way. Read more about [[transformations:derive|derived tables]]. | + | Derived tables is a powerful feature that allows transforming data in a non-linear way. When one table is derived from another (source) table it replicates the final result of the latter. So if the source table changes, the derived table changes automatically. In everything else derived tables is just a regular table and can further be modified using various |
+ | |||
+ | Since you can derive | ||
+ | |||
+ | Circular dependencies are not allowed in EasyMorph. I.e. you can't append table A to table B if table A is derived from table B directly or indirectly. | ||
==== Data Export ==== | ==== Data Export ==== | ||
- | Exporting data is performed using export transformations. They can be inserted at any point of transformation sequence. Export transformations | + | Exporting data is performed using export transformations. They can be inserted at any point of transformation sequence. Export transformations |
- | Export | + | Exporting data to databases is done using [[transformations: |
==== Auto-documentation ==== | ==== Auto-documentation ==== | ||
Line 38: | Line 56: | ||
==== Command-line execution ==== | ==== Command-line execution ==== | ||
EasyMorph projects can be executed from command line thus allowing integration with third-party applications. Read more about [[command_line|command line parameters]]. | EasyMorph projects can be executed from command line thus allowing integration with third-party applications. Read more about [[command_line|command line parameters]]. | ||
+ | |||
+ | **See also:** | ||
+ | * [[http:// | ||
+ | * [[http:// |
overview.txt · Last modified: 2022/07/22 04:36 by dmitry