transformations:start
Actions
List of all actions available in EasyMorph:
Import
-
-
Import dataset - import dataset from a file in the native EasyMorph data format (.dset).
-
-
-
-
-
-
-
-
-
Create
Calendar - create a sequence of dates in specified date range
Create List - create a list of up to 100 manually entered values
File List - create a list of files in specified folder
Folder List - create a list of folders in specified folder
Parameter table - creates a single-row table with parameter values as columns
Sequence - generate a sequence of numbers from 1 to N
Input - obtain input dataset from a calling project
Sandbox - create a table with temporary static snapshot of data
Aggregate - calculate aggregates (subtotals) like sum or count grouped by one or more fields.
-
-
Clean up - remove particular values from a column.
-
-
Lookup - replace values in a column using a lookup table.
Merge another table - merge (join) one or more columns from another table where certain columns in both tables match.
-
Peek - create a new column using a single value from another table.
-
-
-
Replace - replace particular values in a column with new ones.
Rule - calculate or replace a column using multiple nested IF..THEN…ELSE conditions.
-
Sort - sort table by one or more columns.
-
Cross merge - Create a table with all possible combinations (i.e. Cartesian product) of rows in two tables.
-
-
-
Group - Assign a group name (or flag) to selected column values.
Interval merge - Merge columns from another table where key values fall into an interval defined by two columns.
-
Match - Find text strings in another table, that are contained in the current table.
Pivot - Create a matrix table by pivoting.
-
-
-
Running total - Calculate rank, cumulative count, sum or % from total sum.
Sanitize - Remove hidden system characters, extra spaces, and line breaks.
-
-
-
-
-
Table metadata - Obtain column names, total row count and other table metadata.
-
Unpivot - Convert a matrix table into a straight table.
Deduplicate rows - remove duplicate rows in entire table based on all or selected columns.
Filter - filter rows by selecting/deselecting column values.
-
-
Filter by type - keep or remove only rows with values of particular data type (e.g. errors).
Keep duplicates - keep only duplicate rows based on all or selected columns.
Keep min/max - keep/remove rows with the top N biggest/smallest values.
-
Keep matching - keep rows with values that exist in another table.
-
-
Export
-
-
-
Export dataset - export dataset into a file in the native EasyMorph data format (.dset).
-
-
-
Workflow / Internal
Call - pass table data to another project and run it once.
Either table - between current table and another table choose one that is not empty.
Halt on condition - stop project execution with an error if a condition is TRUE for any row.
Iterate - run another EasyMorph project once for each row in table.
-
Status - display custom project execution status message.
-
Wait - pause execution for specified number of seconds.
Workflow / External
Database command - create/delete/truncate DB table or send a custom SQL command to a database (e.g. to bulk load a file).
-
-
-
-
Fetch email - fetch email messages and their attachments from a mail server (Exchange or IMAP).
File command - performs basic file operations such as copy/move/rename/delete/unzip.
File transfer - transfer files over SFTP or SCP to or from a remote computer.
-
PowerShell - executes one or more PowerShell statements.
-
-
Send email - send an email with attachment to one or more recipients.
SSH command - run one or several commands on a remote computer using the SSH protocol.
-
XSLT - transform given XML file using XSLT stylesheets.
transformations/start.txt · Last modified: 2018/08/15 18:24 by dmitry