All actions in EasyMorph

See also: All integrations in EasyMorph.

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

Icon 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.

Fun fact: this HTML page has been generated automatically using an EasyMorph project that parses the application's source code.

EasyMorph gives you data superpowers. Try it today.

Free download   Book a demo