All actions in EasyMorph

Actions marked with an asterisk (*) in the table below are not available in the free edition.

Action name	Category	Description
Aggregate	Transform / Basic / Math	Calculate aggregates (totals), such as sum or count, grouped by one or more columns.
Amazon S3 command	Workflow / App/Cloud	Perform an AWS S3 command such as upload or download a file.
Append another table	Transform / Basic	Append another table as new rows at the bottom, or new columns.
Breakpoint	Workflow / Internal	Stop project execution. The action only works in Desktop and only in the current module.
Bulk export to database^*	Export / Database	Fast export into a database table (only a limited set of target databases is supported).
Calculate new column(s)	Transform / Basic / Math	Add one or more columns calculated as expressions.
Calendar	Create / Generate	Generate a sequence of dates for specified time period.
Call another module/project	Workflow / Internal	Run another module or project. Optionally, return a result dataset.
Clean up	Transform / Basic	Remove values from a column using one or more rules. Unlike Filter, it doesn't remove rows but makes cells empty.
Construct JSON	Transform / Advanced	Roll up column values into one JSON or one JSON per group.
Convert data type	Transform / Basic	Convert column values from one data type (e.g. text) to another (e.g. number).
Create buckets	Transform / Advanced	Create a column with constant-width ranges (buckets) that another column's values are falling into.
Create list	Create / Generate	Create a new column by entering or pasting a list of up to 100 values.
Cross merge	Transform / Advanced	Create a table with all possible combinations (i.e. Cartesian product) of rows in two tables.
Database command	Workflow / External	Send a command to a database (e.g. create a table), or execute an arbitrary SQL statement (e.g. bulk load a file).
Deduplicate rows	Transform / Filters	Remove duplicate rows in entire table based on all or selected columns.
Delete database rows	Workflow / External	Delete rows from a database table using a query condition.
Delete matching database rows	Workflow / External	Delete rows in a database table where key fields match (or don't match) EasyMorph table.
Distribute total	Transform / Math	Break down a total/subtotal proportionally to a group of numbers (weights).
Download file	Workflow / External	Download a file from the internet over HTTP or FTP and save it.
EasyMorph Server command	Workflow / App/Cloud	Trigger a task, or upload/download/delete a file on a remote EasyMorph Server.
Either table	Workflow / Internal	Between the current table and another table choose the one that is not empty.
Enumerate groups	Transform / Advanced	Enumerate all combinations of values in selected columns.
Enumerate rows	Transform / Basic	Add row counts starting from 1 for entire table or inside groups.
Excel command (experimental)^*	Workflow / External	Perform an action with an Excel spreadsheet.
Export Google Sheets	Export / App/Cloud	Export dataset into a new or existing Google Sheets workbook.
Export as plain text	Export / File	Export a column into a file as plain text.
Export dataset	Export / File	Export dataset into a file in native EasyMorph format.
Export into Excel file	Export / File	Export current dataset into a new or existing Excel spreadsheet (.xlsx).
Export into Qlik file	Export / File	Export current dataset into a Qlik data file (.qvd).
Export into delimited text file	Export / File	Export current dataset into a delimited text file (e.g. in CSV format).
Export to Airtable	Export / App/Cloud	Export dataset into an Airtable table.
Export to Salesforce	Export / App/Cloud	Insert records into a Salesforce object.
Export to SharePoint list	Export / App/Cloud	Append rows to SharePoint list.
Export to Tableau	Export / App/Cloud / File	Publish a data source to Tableau Server/Online, or export into a Hyper or TDE file.
Export to XML	Export / File	Export to XML file.
Export to database	Export / Database	Export current dataset into a database table.
Fetch email^*	Workflow / External	Retrieve emails and generate a table with email attributes (sender, subject, etc.). Save attachments.
File command	Workflow / External	Perform a file operation such as file copying, moving, deleting, or unzipping.
File transfer	Workflow / External	Download/upload files over SFTP/SCP.
Fill down	Transform / Advanced	Fill empty cells down with nearest non-empty value in selected columns.
Fill right	Transform / Advanced	Fill empty cells to the right in particular row.
Filter	Transform / Basic / Filters	Remove or leave only rows with selected values in a column.
Filter by condition	Transform / Filters	Keep only rows where condition is satisfied (i.e. is true).
Filter by search	Transform / Filters	Search column values and keep or remove only the matching ones.
Filter by type	Transform / Filters	Keep or remove only rows with values of particular data type (e.g. errors).
Generate documentation	Workflow / External	Generate HTML documentation for an EasyMorph project.
Generate unique identifiers	Transform / Advanced	Add a new column with generated global unique identifiers (GUIDs) for each row.
Google Drive command	Workflow / App/Cloud	Perform a Google Drive command.
Group	Transform / Advanced	Assign a group name (or flag) to selected column values.
Halt on condition	Workflow / Internal	Stop executing project with an error if condition is true.
Halt on data type mismatch	Workflow / Internal	Halt if a column value has a wrong data type.
Import Excel spreadsheet	Import / File	Import data from a sheet or range in an Excel spreadsheet.
Import Google Sheets	Import / App/Cloud	Import a sheet from a Google Sheets workbook.
Import JSON from file	Import / File	Import JSON(s) from one or multiple text files.
Import Qlik QVD file	Import / File	Import a Qlik data file (.qvd).
Import SAS file	Import / File	Import a SAS file (.sas7bdat).
Import SPSS file	Import / File	Import a SPSS/PSPP file (.sav).
Import SharePoint list	Import / App/Cloud	Import a SharePoint list or its view.
Import XML file	Import / File	Import data from an XML file.
Import dataset	Import / File	Import dataset from a file in the native EasyMorph format.
Import delimited text file	Import / File	Import tabular data from a delimited text file (e.g. in CSV format).
Import fixed width text	Import / File	Import tabular data with fixed width columns from a text file.
Import from Airtable	Import / App/Cloud	Imports table data from an Airtable base.
Import from Google Analytics	Import / App/Cloud	Import metrics from Google Analytics.
Import from Pipedrive	Import / App/Cloud	Import data from Pipedrive such as deals, organizations, or persons.
Import from Salesforce	Import / App/Cloud	Imports rows from Salesforce object, and, optionally, its child/parent objects.
Import from database	Import / Database	Import table from a relational database using a visual query or custom SQL.
Import plain text	Import / File	Import a text file as is without parsing.
Incoming webhooks	Workflow / External	Receive incoming webhook requests from EasyMorph Gateway and confirm processing.
Input	Create / Input	Obtain the input dataset from another project. That project should use the Call action to pass its dataset into this project.
Interval merge	Transform / Advanced	Merge two tables based on whether values in one table are within boundaries defined by two columns in another table.
Iterate	Workflow / Internal	Iterate through table values passing them to another EasyMorph project or module as parameters.
Iterate Web request	Workflow / App/Cloud / External	Send multiple uniform HTTP requests to an endpoint and capture the responses.
Iterate column	Workflow / Internal	Pass a dataset column by column into another module/project and append results back into one dataset.
Iterate program^*	Workflow / External	Run an external application once per each line in table.
Iterate table	Workflow / Internal	Iterate through table values passing them to another EasyMorph project or module as parameters together with another table.
Keep duplicates	Transform / Filters	Keep only duplicate rows based on all or selected columns.
Keep min/max	Transform / Filters	Keep/remove rows with biggest/smallest values.
Keep/remove columns	Transform / Basic	Keep or remove selected columns.
Keep/remove matching	Transform / Filters	Keep or remove only rows with values that exist in another table.
Label columns	Transform / Advanced	Make column names from one or more top rows.
Linear regression	Transform / Math	Calculate simple linear regression for a series of values.
List of files	Create / Generate	Generate a list of files in a specified folder. Optionally, scan folders recursively.
List of folders	Create / Generate	Generate a list of folders in a specified folder. Optionally, scan folders recursively.
Lookup	Transform / Basic	Add or replace a column using a lookup table. It's similar to VLOOKUP function in Excel.
Make date/time columns	Transform / Advanced	Create column(s) with date attributes such as year, quarter, or week number.
Match	Transform / Advanced	Find if values of a column match values in another table.
Merge another table	Transform / Basic	Merge columns from another table where certain columns match, using lookup or join mode.
Modify column(s)	Transform / Basic / Math	Replace values in one or more columns using expressions.
OneDrive command	Workflow / App/Cloud	Perform a OneDrive command such as download or upload a file.
Parameter table	Create / Generate	Create a 1-line table with project or module parameters values as columns.
Parse JSON	Transform / Advanced	Parse one or more JSONs into a tabular dataset.
Parse XML	Transform / Advanced	Parse XML data into a tabular dataset.
Peek	Transform / Basic	Take a single value from another table (e.g. total) and append it as a new column.
Pivot	Transform / Advanced	Create a matrix table from a straight table.
Power BI command	Workflow / App/Cloud	Perform a Power BI command.
PowerShell^*	Workflow / External	Execute one or more PowerShell commands.
Project metadata	Import / File	Generate lists of actions, connectors, parameters, and similar metadata of one or multiple EasyMorph projects.
Qlik Sense command	Workflow / App/Cloud	Execute a Qlik Sense command remotely.
Regular expression	Transform / Advanced	Create a new column with regular expression matches
Remove empty columns	Transform / Advanced	Remove columns where all values are the same or empty.
Remove empty rows	Transform / Advanced	Remove rows where all values are empty or whitespace.
Rename columns	Transform / Basic	Rename one or more columns.
Rename columns with lookup	Transform / Advanced	Rename multiple columns using a lookup table.
Reorder columns	Transform / Basic	Re-order columns in table.
Repeat	Workflow / Internal	Recursively call another module/project until its result table becomes empty.
Repeat rows	Transform / Advanced	Repeat each row as many times as specified in given column.
Replace	Transform / Basic	Replace selected values in a column with new ones.
Replace with lookup	Transform / Advanced	Replace substrings in one or many columns using a lookup table.
Rule	Transform / Basic	Multiple nested if/then/else conditions used to calculate a column.
Run program^*	Workflow / External	Run an external application. If no application specified the command line will be executed as a Windows shell command.
Running total	Transform / Math	Calculate rank, cumulative count, sum or percent from total sum for a column.
SSH command^*	Workflow / External	Connect to a remote computer using SSH and execute one or more commands.
Sandbox	Create / Input	Temporary table for ad hoc data manipulations.
Sanitize text	Transform / Advanced	Remove hidden system characters, extra spaces, and line breaks.
Select columns by lookup	Transform / Advanced	Select columns which names exist in another table.
Select matching database rows	Import / Database	Select rows in a database table where key fields match EasyMorph table.
Send email	Workflow / External	Send an email with attachment to one or more recipients.
Sequence	Create / Generate	Generate a sequence of numbers starting from 1.
SharePoint command	Workflow / App/Cloud	Perform a SharePoint command such as downloading, uploading, or deleting a file.
Shared memory	Workflow / Internal	Remember and recall values from shared key-value storage.
Shift column up/down	Transform / Advanced	Shift column values up or down.
Skip actions on condition	Workflow / Internal	Skip the rest of actions in table if condition is true.
Sort	Transform / Basic	Sort table by one or more columns.
Split delimited file	Import / File	Split a delimited text file into smaller files based on row count, or column values.
Split delimited text into columns	Transform / Advanced	Split text values that are delimited with a separator into columns.
Split delimited text into rows	Transform / Advanced	Split text values delimited by a separator into multiple rows.
Split fixed width text	Transform / Advanced	Split text values with fixed width columns into multiple columns.
Spreadsheet metadata	Import / File	Create a list with names of all sheets in a spreadsheet.
Start/finish exclusive access	Workflow / Internal	Ensure exclusive access to a resource.
Statistical aggregation	Transform / Math	Calculate one or more statistical functions for specified column.
Status	Workflow / Internal	Update project execution status.
Synchronize	Workflow / Internal	Wait until another table is calculated.
Table metadata	Transform / Advanced	Produce a table with the current dataset's metadata: column names, total row and column counts.
Table-wide replace	Transform / Advanced	Remove or replace a value across selected columns.
Tableau Server command	Workflow / App/Cloud	Trigger a Tableau Server/Online action remotely.
Total/subtotals	Transform / Math	Column total or group subtotals added as a new column.
Trim table	Transform / Filters	Keep or remove a fixed number of rows from the top or the bottom of table.
Trim table by condition	Transform / Filters	Remove rows above or below the first row where a condition is satisfied.
Unpivot	Transform / Advanced	Convert a matrix table into a straight table.
Update database table^*	Workflow / External	Updates a database table with data from EasyMorph.
Update/Delete rows in SharePoint list^*	Workflow / App/Cloud	Change or delete rows in a SharePoint list.
Update/delete records in Salesforce^*	Workflow / App/Cloud	Update/delete records in a Salesforce object.
Update/delete rows in Airtable^*	Workflow / App/Cloud	Update or delete rows in a table in Airtable
Wait	Workflow / Internal	Pause project execution for the specified number of seconds.
Web request	Workflow / App/Cloud / External	Send an HTTP request and capture the response.
XSLT transformation	Workflow / External	Transform an XML file using an XSLT stylesheet.