User Tools

Site Tools


overview

Differences

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

Link to this comparison view

Both sides previous revisionPrevious revision
Next revisionBoth sides next revision
overview [2015/01/31 15:08] dmitryoverview [2016/05/24 00:42] 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. Currently, EasyMorph can import these file formats:+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: 
 +  * 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 but not .xls)+  * Excel files (.xlsx.xls)
   * QlikView's QVD files   * QlikView's QVD files
 +  * SAS files (.sas7bdat)
  
-One imported file creates one table. Once tables are loaded into EasyMorph they can further be modified using transformations applied one after another.+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. 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.
  
 ==== 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 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). 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).
overview.txt · Last modified: 2022/07/22 04:36 by dmitry

Donate Powered by PHP Valid HTML5 Valid CSS Driven by DokuWiki