Differences

This shows you the differences between two versions of the page.

--- overview [2017/09/14 06:21] – [Data Import] dmitry
+++ overview [2018/05/09 19:38] – [Expressions] dmitry
@@ Line 2: / Line 2: @@
 ==== Data Import ====
-In order to start transforming data in EasyMorph, all data subject to manipulations has to be imported into EasyMorph as tables. As of version 2.8 EasyMorph supports the following data sources:
+In order to start transforming data in EasyMorph, all data subject to manipulations has to be imported into EasyMorph as tables. As of version 3.8 EasyMorph supports the following data sources:
   * Relational databases (Oracle, MS SQL Server, MySQL, PostgreSQL, SQLite)
-  * ODBC data sources
+  * ODBC data sources (Oracle, MS SQL Server, MySQL, PostgreSQL, SQLite, Amazon Redshift, Vertica, SAP HANA, Apache Hive)
   * Text files with delimiters (e.g. CSV)
-  * Excel files (.xlsx, .xls)
+  * Text files with fixed with columns
-  * QlikView's QVD files
+  * Excel files (.xlsx, .xlsm, .xls)
+  * Qlik data files (.qvd)
   * SAS files (.sas7bdat)
+  * SPSS/PSPP files (.sav)
 Once tables are loaded into EasyMorph they can further be modified using transformations that are applied one after another.
-Technically speaking, import is performed by special import transformations which are available from "Create table" menu rather than "Add transformation" menu where all other transformations reside.
+Import is performed by import actions which are available in the Main menu, by pressing "Add action".
-==== 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 a table.
-Transformations are executed consequently, step-by-step. One transformation is one step. Every transformation is applied to the result (output) of previous transformation. Therefore sequence of transformations is important. The same transformations in different order would usually produce different result (although not always).
+Files can be loaded by simply dragging them into EasyMorph.
+==== Actions ====
+All manipulations with tables are done with the help of various actions. E.g. renaming a column is an action. Filtering, joining, aggregations -- all are actions. Actions can be one of 5 types:
-Final state (or result) of a table is the result of all transformations of this table applied consequently, one after another.
+  * Create -- actions that create or generate a table
+  * 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:append|Append Table]]) require another table. These transformations have two inputs -- one input is the result of previous transformation in the same table and the other input is the final state (i.e. the result of last transformation) of the other table.
+Actions are executed consequently, step-by-step. One action is one step. Every action is applied to the result (output) of previous action. Therefore sequence of actions is important. The same actions in different order would usually produce a different result (although not always).
-Here is full list of all [[transformations:start|transformations]].
+Final state (or result) of a table is the result of all actions of this table applied consequently, one after another.
+Some actions (e.g. [[transformations:append|Append Table]]) require another table. These actions have two inputs -- one input is the result of previous action in the same table and the other input is the final state (i.e. the result of last action) of the other table.
+Here is full list of all [[transformations:start|actions]].
 ==== Expressions ====
-Some transformations can use [[syntax:start|expressions]] in order to calculate new columns or filter rows. These expressions can be composed using arithmetical operations, column names and functions. Read more about [[syntax:start|expressions]].
+Some actions can use [[syntax:start|expressions]] in order to calculate new columns or filter rows. These expressions can be composed using arithmetical operations, column names and functions. Read more about [[syntax:start|expressions]].
 ==== Derived tables ====