Both sides previous revisionPrevious revisionNext revision | Previous revisionNext revisionBoth sides next revision |
transformations:start [2020/06/29 09:03] – [Workflow / External] dmitry | transformations:start [2020/12/06 18:53] – [Workflow / External] dmitry |
---|
====== Actions ====== | ====== Actions ====== |
| |
List of all actions available in EasyMorph: | All the actions available in EasyMorph: |
| |
==== Import ==== | ==== Import ==== |
* [[transformations:importspss|Import SPSS file]] - import data from a SPSS/PSPP file (.sav). | * [[transformations:importspss|Import SPSS file]] - import data from a SPSS/PSPP file (.sav). |
* [[transformations:importxml|Import XML file]] - import data from an XML file. | * [[transformations:importxml|Import XML file]] - import data from an XML file. |
| * [[transformations:projectmetadata|Project metadata]] - project metadata such as list of connectors or parameters. |
* [[transformations:selectdbrowsbykeys|Select matching database rows]] - import rows from a database table where key values match (or don't match) key values in EasyMorph table. | * [[transformations:selectdbrowsbykeys|Select matching database rows]] - import rows from a database table where key values match (or don't match) key values in EasyMorph table. |
* [[transformations:filesplitter|Split delimited text file]] - split large file into smaller chunks without loading it into EasyMorph. | * [[transformations:filesplitter|Split delimited text file]] - split large file into smaller chunks without loading it into EasyMorph. |
* [[transformations:group|Group]] - Assign a group name (or flag) to selected column values. | * [[transformations:group|Group]] - Assign a group name (or flag) to selected column values. |
* [[transformations:intervalmerge|Interval merge]] - Merge columns from another table where key values fall into an interval defined by two columns. | * [[transformations:intervalmerge|Interval merge]] - Merge columns from another table where key values fall into an interval defined by two columns. |
* [[transformations:iteratecolumns|Iterate columns]] - Iterate module/project by passing it columns one by one. Append the results back into one table. | |
* [[transformations:labelcolumns|Label columns]] - Name columns using values from top rows. | * [[transformations:labelcolumns|Label columns]] - Name columns using values from top rows. |
* [[transformations:match|Match]] - Find text strings in another table, that are contained in the current table. | * [[transformations:match|Match]] - Find text strings in another table, that are contained in the current table. |
* [[transformations:keepduplicates|Keep duplicates]] - keep only duplicate rows based on all or selected columns. | * [[transformations:keepduplicates|Keep duplicates]] - keep only duplicate rows based on all or selected columns. |
* [[transformations:filterminmax|Keep min/max]] - keep/remove rows with the top N biggest/smallest values. | * [[transformations:filterminmax|Keep min/max]] - keep/remove rows with the top N biggest/smallest values. |
* [[transformations:keepdifferent|Keep mismatching]] - keep rows with values that don't exist in another table. | |
* [[transformations:keepremovematching|Keep/remove matching]] - keep or remove rows with values that exist in another table. | * [[transformations:keepremovematching|Keep/remove matching]] - keep or remove rows with values that exist in another table. |
* [[transformations:keepexisting|Keep matching]] - keep rows with values that exist in another table. | |
* [[transformations:keeptop|Trim table]] - keep/remove top/bottom N rows. | * [[transformations:keeptop|Trim table]] - keep/remove top/bottom N rows. |
* [[transformations:trimbycondition|Trim table by condition]] - keep/remove rows above/below first row matching condition. | * [[transformations:trimbycondition|Trim table by condition]] - keep/remove rows above/below first row matching condition. |
| |
==== Export ==== | ==== Export ==== |
| * [[transformations:bulkexportdb|Bulk export into database]] - bulk export into database table (SQL Server only). |
* [[transformations:exportdb|Export into database]] - export EasyMorph table into database table. | * [[transformations:exportdb|Export into database]] - export EasyMorph table into database table. |
* [[transformations:exporttext|Export into delimited text file]] - export data into CSV or another delimited text format. | * [[transformations:exporttext|Export into delimited text file]] - export data into CSV or another delimited text format. |
* [[transformations:call|Call]] - pass table data to another project and run it once. | * [[transformations:call|Call]] - pass table data to another project and run it once. |
* [[transformations:either|Either table]] - between current table and another table choose one that is not empty. | * [[transformations:either|Either table]] - between current table and another table choose one that is not empty. |
* [[transformations:halt|Halt on condition]] - stop project execution with an error if the specified condition is fulfilled. | * [[transformations:halt|Halt on condition]] - abort project execution if the specified condition is fulfilled. |
| * [[transformations:haltontypemismatch|Halt on data type mismatch]] - abort project execution if a value in specified column(s) has a wrong type. |
* [[transformations:iterate|Iterate]] - run another module/project once for each row in table. | * [[transformations:iterate|Iterate]] - run another module/project once for each row in table. |
* [[transformations:iteratecolumns|Iterate columns]] - run another module/project once for each column in table and automatically append all returned columns into one table. | * [[transformations:iteratecolumns|Iterate columns]] - run another module/project once for each column in table and automatically append all returned columns into one table. |
* [[transformations:iteratetable|Iterate table]] - run another module/project once for each row in table and pass another table to it. | * [[transformations:iteratetable|Iterate table]] - run another module/project once for each row in table and pass another table to it. |
| * [[transformations:repeat|Repeat]] - run another module/project until/while its output is empty |
* [[transformations:skiponcondition|Skip on condition]] - skip the rest of action in table if the specified condition is fulfilled. | * [[transformations:skiponcondition|Skip on condition]] - skip the rest of action in table if the specified condition is fulfilled. |
* [[transformations:status|Status]] - display custom project execution status message. | * [[transformations:status|Status]] - display custom project execution status message. |
* [[transformations:webrequest|Web Request]] - send an HTTP request to a web API and receive a response. | * [[transformations:webrequest|Web Request]] - send an HTTP request to a web API and receive a response. |
* [[transformations:xslt|XSLT]] - transform given XML file using XSLT stylesheets. | * [[transformations:xslt|XSLT]] - transform given XML file using XSLT stylesheets. |
| |
| :?: If you need an action that is not currently available in EasyMorph please feel free to make a feature request on the [[https://community.easymorph.com|Community forum]] |