All actions in EasyMorph

Note that the free edition doesn't include actions: Fetch Email, SSH Command, Run Program, Iterate Program, PowerShell, Split Delimited Files, Input.

Icon Action name Category Description
AggregateTransform / BasicCalculate aggregates (totals), such as sum or count, grouped by one or more columns.
Append another tableTransform / BasicAppend another table as new rows at the bottom, or new columns.
Calculate new column(s)Transform / BasicAdd one or more columns calculated as expressions.
CalendarCreate / GenerateGenerate a sequence of dates for specified time period.
Call another projectWorkflow / InternalRun another project and return result table. The called project can use the Input action to obtain a dataset from the calling project.
Clean upTransform / BasicRemove values from a column using one or more rules. Unlike Filter, it doesn't remove rows but makes cells empty.
Convert data typeTransform / BasicConvert column values from one data type (e.g. text) to another (e.g. number).
Create listCreate / GenerateEnter or paste a list of up to 100 values.
Cross mergeTransform / AdvancedCreate a table with all possible combinations (i.e. Cartesian product) of rows in two tables.
Database commandWorkflow / ExternalSend a command to a database (e.g. create a table), or execute an arbitrary SQL statement (e.g. bulk load a file).
Deduplicate rowsTransform / FiltersRemove duplicate rows in entire table based on all or selected columns.
Delete database rowsWorkflow / ExternalDelete rows from a database table using a query condition.
Delete matching database rowsWorkflow / ExternalDelete rows in a database table where key fields match (or don't match) EasyMorph table.
Download fileWorkflow / ExternalDownload a file from the internet over HTTP or FTP and save it.
EasyMorph Server commandWorkflow / ExternalTrigger a task, or upload/download/delete a file on a remote EasyMorph Server.
Either tableWorkflow / InternalBetween the current table and another table choose the one that is not empty.
Enumerate rowsTransform / BasicAdd a new column with row numbers starting from 1.
Export datasetExport / FileExport dataset into a file in native EasyMorph format.
Export into Excel fileExport / FileExport current dataset into a new or existing Excel spreadsheet (.xlsx).
Export into Qlik fileExport / FileExport current dataset into a Qlik data file (.qvd).
Export into delimited text fileExport / FileExport current dataset into a delimited text file (e.g. in CSV format).
Export to 1010dataExport / DatabaseExport to a 1010data cloud database.
Export to TableauExport / FilePublish a data source to Tableau Server, or export into a Tableau Data Extract file.
Export to databaseExport / DatabaseExport current dataset into a database table.
Fetch emailWorkflow / ExternalRetrieve emails and generate a table with email attributes (sender, subject, etc.). Save attachments.
File commandWorkflow / ExternalPerform a file operation such as file copying, moving, deleting, or unzipping.
File transferWorkflow / ExternalDownload/upload files over SFTP/SCP.
Fill downTransform / AdvancedFill empty cells down with nearest non-empty value in selected columns.
Fill rightTransform / AdvancedFill empty cells to the right in particular row.
FilterTransform / Basic / FiltersRemove or leave only rows with selected values in a column.
Filter by conditionTransform / FiltersKeep only rows where condition is satisfied (i.e. is true).
Filter by searchTransform / FiltersSearch column values and keep or remove only the matching ones.
Filter by typeTransform / FiltersKeep or remove only rows with values of particular data type (e.g. errors).
Generate unique identifiersTransform / AdvancedAdd a new column with generated global unique identifiers (GUIDs) for each row.
GroupTransform / AdvancedAssign a group name (or flag) to selected column values.
Halt on conditionWorkflow / InternalStop executing project with an error if condition is true.
Import Excel spreadsheetImport / FileImport data from a sheet or range in an Excel spreadsheet.
Import Qlik QVD fileImport / FileImport a Qlik data file (.qvd).
Import SAS fileImport / FileImport a SAS file (.sas7bdat).
Import SPSS fileImport / FileImport a SPSS/PSPP file (.sav).
Import XML fileImport / FileImport data from an XML file.
Import datasetImport / FileImport dataset from a file in the native EasyMorph format.
Import delimited text fileImport / FileImport tabular data from a delimited text file (e.g. in CSV format).
Import fixed width textImport / FileImport tabular data with fixed width columns from a text file.
Import from databaseImport / DatabaseImport table from a relational database using a visual query or custom SQL.
InputCreate / InputObtain the input dataset from another project. That project should use Call action to pass its dataset into this project.
Interval mergeTransform / AdvancedMerge two tables based on whether values in one table are within boundaries defined by two columns in another table.
IterateWorkflow / InternalIterate through table values passing them to another EasyMorph project as parameters.
Iterate programWorkflow / ExternalRun an external application once per each line in table.
Iterate tableWorkflow / InternalIterate through table values passing them to another EasyMorph project as parameters together with another table.
Keep duplicatesTransform / FiltersKeep only duplicate rows based on all or selected columns.
Keep matchingTransform / FiltersKeep only rows with values that exist in another table.
Keep min/maxTransform / FiltersKeep/remove rows with biggest/smallest values.
Keep mismatchingTransform / FiltersKeep only rows with values that don't exist in another table.
Label columnsTransform / AdvancedMake column names from one or more top rows.
List of filesCreate / GenerateGenerate a list of files in a specified folder. Optionally, scan folders recursively.
List of foldersCreate / GenerateGenerate a list of folders in a specified folder. Optionally, scan folders recursively.
LookupTransform / BasicAdd or replace a column using a lookup table. It's similar to VLOOKUP function in Excel.
MatchTransform / AdvancedFind if values of a column match values in another table.
Merge another tableTransform / BasicMerge columns from another table where certain columns match, using lookup or join mode.
Modify column(s)Transform / BasicReplace values in one or more columns using expressions.
Parameter tableCreate / GenerateCreate a 1-line table with project parameters values as columns.
PeekTransform / BasicTake a single value from another table (e.g. total) and append it as a new column.
PivotTransform / AdvancedCreate a matrix table from a straight table.
PowerShellWorkflow / ExternalExecute one or more PowerShell commands.
Qlik Sense commandWorkflow / ExternalExecute a Qlik Sense command remotely.
Regular expressionTransform / AdvancedCreate a new column with regular expression matches
Remove columnsTransform / BasicRemove one or more columns.
Remove empty columnsTransform / AdvancedRemove columns where all values are the same or empty.
Rename columnsTransform / BasicRename one or more columns.
Rename columns with lookupTransform / AdvancedRename multiple columns using a lookup table.
Reorder columnsTransform / BasicRe-order columns in table.
ReplaceTransform / BasicReplace selected values in a column with new ones.
RuleTransform / BasicMultiple nested if/then/else conditions used to calculate a column.
Run programWorkflow / ExternalRun an external application. If no application specified the command line will be executed as a Windows shell command.
Running totalTransform / AdvancedCalculate rank, cumulative count, sum or percent from total sum for a column.
SSH commandWorkflow / ExternalConnect to a remote computer using SSH and execute one or more commands.
SandboxCreate / InputTemporary table for ad hoc data manipulations.
Sanitize textTransform / AdvancedRemove hidden system characters, extra spaces, and line breaks.
Select by lookupTransform / AdvancedSelect columns which names exist in another table.
Select columnsTransform / BasicRemove all columns except selected.
Select matching database rowsImport / DatabaseSelect rows in a database table where key fields match EasyMorph table.
Send emailWorkflow / ExternalSend an email with attachment to one or more recipients.
SequenceCreate / GenerateGenerate a sequence of numbers starting from 1.
Shift column up/downTransform / AdvancedShift column values up or down.
SortTransform / BasicSort table by one or more columns.
Split delimited fileImport / FileSplit a delimited text file into smaller files based on row count, or column values.
Split delimited text into columnsTransform / AdvancedSplit text values that are delimited with a separator into columns.
Split delimited text into rowsTransform / AdvancedSplit text values delimited by a separator into multiple rows.
Split fixed width textTransform / AdvancedSplit text values with fixed width columns into multiple columns.
Spreadsheet metadataImport / FileCreate a list with names of all sheets in a spreadsheet.
StatusWorkflow / InternalUpdate project execution status.
SynchronizeWorkflow / InternalWait until another table is calculated.
Table metadataTransform / AdvancedProduce a table with the current dataset's metadata: column names, total row and column counts.
Table-wide replaceTransform / AdvancedRemove or replace a value across selected columns.
Tableau Server commandWorkflow / ExternalExecute a Tableau Server command remotely.
Total/subtotalsTransform / BasicColumn total or group subtotals added as a new column.
Trim tableTransform / FiltersKeep or remove a fixed number of rows from the top or the bottom of table.
Trim table by conditionTransform / FiltersRemove rows above or below the first row where a condition is satisfied.
UnpivotTransform / AdvancedConvert a matrix table into a straight table.
WaitWorkflow / InternalPause project execution for the specified number of seconds.
XSLT transformationWorkflow / ExternalTransform an XML file using an XSLT stylesheet.

The table is generated automatically using an EasyMorph project that parses the application source code.