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 [2016/05/24 00:45] – 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 | ||
* Text files with delimiters (e.g. CSV) | * Text files with delimiters (e.g. CSV) | ||
- | * Excel files (.xlsx | + | * Excel files (.xlsx, .xls) |
* QlikView' | * QlikView' | ||
+ | * SAS files (.sas7bdat) | ||
- | One imported file creates one table. | + | Once tables are loaded into EasyMorph they can further be modified using transformations |
Technically speaking, import is performed by special import transformations which are available from " | Technically speaking, import is performed by special import transformations which are available from " | ||
==== Transformations ==== | ==== Transformations ==== | ||
- | 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. | + | 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 |
Transformations are executed consequently, | Transformations are executed consequently, | ||
Line 26: | Line 29: | ||
==== 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 ==== | ||
Line 38: | Line 45: | ||
==== 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