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 revision
Previous revision
Next revisionBoth sides next revision
overview [2020/11/26 16:50] – [Command-line execution] dmitryoverview [2021/01/14 18:59] – [Data import] dmitry
Line 9: Line 9:
   * Text files with fixed width columns   * Text files with fixed width columns
   * Excel spreadsheets (.xlsx, .xlsm, .xls)   * Excel spreadsheets (.xlsx, .xlsm, .xls)
-  * XML files+  * XML and JSON files
   * Google Sheets   * Google Sheets
   * SharePoint lists   * SharePoint lists
Line 22: Line 22:
  
 Files can be loaded by simply dragging them into EasyMorph. It's possible to load and automatically append multiple files at once. Files can be loaded by simply dragging them into EasyMorph. It's possible to load and automatically append multiple files at once.
 +
 +[[https://easymorph.com/learn/load-file.html|Tutorial: Loading data from files]]\\
 +[[https://easymorph.com/learn/load-database.html|Tutorial: Loading data from databases]]
 +
  
 ==== Actions ==== ==== Actions ====
Line 34: Line 38:
 {{::datamorphing.png?nolink|}} {{::datamorphing.png?nolink|}}
  
-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).+Actions are executed consequently, step-by-step. One action is one step. An action is applied to the result (output) of its previous action. Therefore the order of actions is important. The same actions ordered differently would usually produce a different result (although not always).
  
-The final state (or result) of a table is the result of all actions of this table applied consequently, one after another.+The final state (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. 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.
Line 76: Line 80:
   * EasyMorph datasets (.dset)   * EasyMorph datasets (.dset)
  
-==== Automation ==== +==== Workflow automation ==== 
-EasyMorph workflows can have following automation:+EasyMorph workflows can perform external actions, for instance:
   * File and folder operations (copy/rename/delete/unzip/zip/download)   * File and folder operations (copy/rename/delete/unzip/zip/download)
   * Running external applications, scripts and batch files   * Running external applications, scripts and batch files
Line 83: Line 87:
   * Embedded PowerShell scripting   * Embedded PowerShell scripting
  
 +A workflow can be composed using advanced patterns:
 +  * FOR..EACH type of loops (iterations)
 +  * DO..WHILE/UNTIL type of loops (iterations)
 +  * IF..THEN..ELSE type of conditional branching
 +  * Subroutines
 +  * Error recovery
 +
 +Workflows can have complex hierarchical structure when a project can consist of multiple modules, and each module can consist of multiple table groups. Such a structure allows designing and navigating workflows with hundreds of transformation steps (actions).
 ==== Integration with external systems ==== ==== Integration with external systems ====
 EasyMorph workflows can also integrate and interact with external systems and applications. EasyMorph workflows can also integrate and interact with external systems and applications.
Line 122: Line 134:
   * [[https://easymorph.com/learn.html|Illustrated tutorial]]   * [[https://easymorph.com/learn.html|Illustrated tutorial]]
   * [[https://easymorph.com/download.html|Download EasyMorph (free edition)]]   * [[https://easymorph.com/download.html|Download EasyMorph (free edition)]]
 +  * [[https://easymorph.com|easymorph.com]]
overview.txt · Last modified: 2022/07/22 04:36 by dmitry

Donate Powered by PHP Valid HTML5 Valid CSS Driven by DokuWiki