List of all actions available in EasyMorph:

• Import delimited text file - import data from a delimited text files (e.g. CSV).
• Import Excel file - import data from Excel spreadsheets (.xls,.xlsx).
• Import dataset - import dataset from a file in the native EasyMorph data format (.dset).
• Import fixed width text file -import tabular data with fixed width columns from text file.
• Import from database - import data from a database.
• Import from Google Sheets - import data from a Google Sheets spreadsheet.
• Import Qlik file - import data from a QVD file.
• Import SAS file - import data from a SAS file (.sas7bdat).
• Import SPSS file - import data from a SPSS/PSPP file (.sav).
• Import XML file - import data from an XML file.
• Select matching database rows - import rows from a database table where key values match (or don't match) key values in EasyMorph table.
• Split delimited text file - split large file into smaller chunks without loading it into EasyMorph.
• Spreadsheet metadata - create a list with names of all sheets in a spreadsheet.

• 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.
• Append another table - Append another table as new rows or columns.
• Calculate new column - calculate new column with expression built using arithmetical operations and various functions.
• Clean up - remove particular values from a column.
• Convert data type - convert text dates into number dates.
• Enumerate rows - add column with row numbers.
• 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.
• Modify column - replace existing column with a calculated expression.
• Peek - create a new column using a single value from another table.
• Remove columns
• Rename columns
• Reorder columns
• Replace - replace particular values in a column with new ones.
• Rule - calculate or replace a column using multiple nested IF..THEN…ELSE conditions.
• Select columns
• Sort - sort table by one or more columns.
• Total/subtotals - add column total or group subtotals as a new column.

• Cross merge - Create a table with all possible combinations (i.e. Cartesian product) of rows in two tables.
• Fill down - Fill down empty cells.
• Fill right - Fill empty cells to the right.
• Generate UIDs
• 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.
• Label columns - Name columns using values from top rows.
• Match - Find text strings in another table, that are contained in the current table.
• Pivot - Create a matrix table by pivoting.
• Regular expression - Create a new column with regular expression matches.
• Remove empty columns - Remove columns where all values are the same or empty.
• Remove empty rows - Remove rows where all values are empty or whitespace.
• Rename columns with lookup - Rename multiple columns using a lookup table.
• Running total - Calculate rank, cumulative count, sum or % from total sum.
• Sanitize - Remove hidden system characters, extra spaces, and line breaks.
• Select columns by lookup - Select columns using a lookup table.
• Shift column up/down - Shifts column values up or down.
• Split delimited text into columns - Split delimited values of a column into new columns.
• Split delimited text into rows - Split delimited values of a column into rows.
• Split fixed width text - Split a column with fixed width text values into new columns.
• Table metadata - Obtain column names, total row count and other table metadata.
• Table-wide replace - Remove or replace values across selected columns.
• 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 condition - filter rows that satisfy expression.
• Filter by search - filter rows that contain (or don't contain) search string.
• 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 mismatching - keep rows with values that don't exist in another table.
• Keep matching - keep rows with values that exist in another table.
• Trim table - keep/remove top/bottom N rows.
• Trim table by condition - keep/remove rows above/below first row matching condition.

• Export into database - export EasyMorph table into database table
• Export into delimited text file - export data into CSV or another delimited text format.
• Export into Excel spreadsheet - export data into an Excel spreadsheet.
• Export into Google Sheets - export data into a Google Sheets spreadsheet.
• Export dataset - export dataset into a file in the native EasyMorph data format (.dset).
• Export into Qlik file - export data into a Qlik QVD file.
• Export into 1010data - export into 1010data (experimental, not supported).
• Export into Tableau - export data into a Tableau Data Extract or publish to Tableau Server.
• Export into XML file - export data into a XML file.

• 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.
• Iterate table
• Status - display custom project execution status message.
• Synchronize with another table - wait until another table is calculated.
• Wait - pause execution for specified number of seconds.

• Amazon command - perform an operation with AWS S3 , e.g. upload/download a file.
• Database command - create/delete/truncate DB table or send a custom SQL command to a database (e.g. to bulk load a file).
• Delete database rows - delete rows in a database table that satisfy query condition.
• Delete matching database rows - delete rows in a database table where key values match (or don't match) key values in EasyMorph table.
• Download file - download a file from the internet.
• EasyMorph Server command - Trigger a task, or upload/download/delete a file on a remote EasyMorph Server.
• 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.
• Google Drive command - perform an operation with Google Drive, e.g. download a file.
• Iterate external program - execute external application once for each row in table.
• PowerShell - executes one or more PowerShell statements.
• Qlik Sense command - execute a Qlik Sense command remotely.
• Run external program - execute external application once.
• 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.
• Tableau Server command - trigger extract refresh on a Tableau Server.
• XSLT - transform given XML file using XSLT stylesheets.