https://help.easymorph.com/ Wed, 15 Apr 2026 14:09:46 +0000 FeedCreator 1.8 https://help.easymorph.com/lib/exe/fetch.php?media=wiki:logo.png https://help.easymorph.com/ https://help.easymorph.com/doku.php?id=transformations:addcolumn&rev=1748658083&do=diff CALCULATE NEW COLUMN(S) Category: Transform / Basic Description This action calculates one or more new columns using expression(s). One expression creates one column. Use cases * Creating a calculated result from numeric values in two (or more) other columns. anonymous@undisclosed.example.com (Anonymous) Sat, 31 May 2025 02:21:23 +0000 https://help.easymorph.com/doku.php?id=transformations:aggregate&rev=1736525572&do=diff AGGREGATE Category: Transform / Basic Description This action calculates the aggregates for selected columns, grouped by another set of columns. Use cases Available aggregations: * Sum: generates the total of values. * Count: generates the count of values. anonymous@undisclosed.example.com (Anonymous) Fri, 10 Jan 2025 16:12:52 +0000 https://help.easymorph.com/doku.php?id=transformations:airtablecommand&rev=1626674218&do=diff UPDATE/DELETE ROWS IN AIRTABLE Category: Workflow / App/Cloud Description This action connects to an Airtable database ("base") to delete or update rows in a specified table via API Key and Base ID. Action settings Setting Description anonymous@undisclosed.example.com (Anonymous) Mon, 19 Jul 2021 05:56:58 +0000 https://help.easymorph.com/doku.php?id=transformations:amazoncommand&rev=1739919010&do=diff AMAZON S3 COMMAND Category: Workflow / App/Cloud Description The action performs file operations with Amazon S3 buckets. A configured Amazon S3 connector is required. Capabilities Currently, the following commands are available: * List files * List folders anonymous@undisclosed.example.com (Anonymous) Tue, 18 Feb 2025 22:50:10 +0000 https://help.easymorph.com/doku.php?id=transformations:anonymizehash&rev=1737348223&do=diff ANONYMIZE/HASH Category: Transform / Advanced Description This action deterministically calculates hashes for values in one or multiple columns. Use Cases Using this action, you can anonymize data without affecting its cardinality so it can be used for merging and aggregation. anonymous@undisclosed.example.com (Anonymous) Mon, 20 Jan 2025 04:43:43 +0000 https://help.easymorph.com/doku.php?id=transformations:append&rev=1736544234&do=diff APPEND ANOTHER TABLE Category: Transform / Basic Description This action appends another table to the current dataset. This action can operate in 2 modes: * Append rows * Append columns Use cases * Append rows. The other table (dataset) is appended as new rows at the bottom of the current table. Columns with the same name in both tables appear as one column in the result table. Columns in the appended table that don't exist in the main table are appended on the right.This mod… anonymous@undisclosed.example.com (Anonymous) Fri, 10 Jan 2025 21:23:54 +0000 https://help.easymorph.com/doku.php?id=transformations:azureblobstoragecommand&rev=1740081404&do=diff AZURE BLOB STORAGE COMMAND Category: Workflow / App/Cloud Description This action performs file and folder operations with Azure Blob Storage. A configured Azure Blob Storage connector is required. Capabilities * List file * Download file * Download list of files anonymous@undisclosed.example.com (Anonymous) Thu, 20 Feb 2025 19:56:44 +0000 https://help.easymorph.com/doku.php?id=transformations:boardissuecommand&rev=1742328160&do=diff BOARD/ISSUE COMMAND Category: Workflow / Internal Description This action performs an operation with a board or an issue. (Requires a valid Server license.) Capabilities * List boards * List issues * Archive issue Use cases anonymous@undisclosed.example.com (Anonymous) Tue, 18 Mar 2025 20:02:40 +0000 https://help.easymorph.com/doku.php?id=transformations:breakpoint&rev=1680618143&do=diff BREAKPOINT Category: Workflow / Internal Description This action stops project execution without producing an error. This action only works in EasyMorph Desktop and only in the current module. It's ignored in called/iterated modules or when executed not in EasyMorph Desktop. anonymous@undisclosed.example.com (Anonymous) Tue, 04 Apr 2023 14:22:23 +0000 https://help.easymorph.com/doku.php?id=transformations:bulkexportdb&rev=1732061224&do=diff BULK EXPORT TO DATABASE Category: Export / Database Description This action performs fast export into a database table using the native bulk load capabilities of the target database. The action is intended for exporting large volumes of data (e.g. millions of rows or more) and may not be efficient on small datasets (e.g. with a few hundred rows). anonymous@undisclosed.example.com (Anonymous) Wed, 20 Nov 2024 00:07:04 +0000 https://help.easymorph.com/doku.php?id=transformations:calendar&rev=1739120940&do=diff CALENDAR Category: Create / Generate Description This action creates a table with a list of dates for a specified date range. One row corresponds to one day. Start and end dates can be defined as an absolute or relative date, or defined by a parameter. anonymous@undisclosed.example.com (Anonymous) Sun, 09 Feb 2025 17:09:00 +0000 https://help.easymorph.com/doku.php?id=transformations:call&rev=1748657561&do=diff CALL ANOTHER MODULE/PROJECT Category: Workflow / Internal Description This action runs another module or project once. The input dataset of the Call action can be passed into the called module (project). In this case, the called module or project should use anonymous@undisclosed.example.com (Anonymous) Sat, 31 May 2025 02:12:41 +0000 https://help.easymorph.com/doku.php?id=transformations:callpython&rev=1755110210&do=diff CALL PYTHON Category: Workflow / External Description The action executes the specified Python script. For more details, read Using Python in EasyMorph. Capabilities * Executing a Python script from an EasyMorph workflow * Obtaining the workflow parameters in the Python script anonymous@undisclosed.example.com (Anonymous) Wed, 13 Aug 2025 18:36:50 +0000 https://help.easymorph.com/doku.php?id=transformations:callwithanothertable&rev=1740869750&do=diff CALL WITH ANOTHER TABLE Category: Workflow / Internal Description This action calls another module or project, passes another table into the module/project, and can append the results. Use cases This action can be used to build data quality verification pipelines and can be used for custom reusable data quality checks. anonymous@undisclosed.example.com (Anonymous) Sat, 01 Mar 2025 22:55:50 +0000 https://help.easymorph.com/doku.php?id=transformations:catalogcommand&rev=1746589475&do=diff CATALOG COMMAND Category: Workflow / External Description This action performs a process on the Data Catalog or Data Catalog resources. Capabilities List of commands which EasyMorph can operate with: * List Catalog items * List Catalog directories anonymous@undisclosed.example.com (Anonymous) Wed, 07 May 2025 03:44:35 +0000 https://help.easymorph.com/doku.php?id=transformations:chatgpt&rev=1746478897&do=diff ASK AI Category: Workflow / App/Cloud Description The action allows free-form prompts to ChatGPT or other LLM services to be sent (as long as their API is ChatGPT-compatible). The prompts can be parameterized using workflow parameters. Action settings anonymous@undisclosed.example.com (Anonymous) Mon, 05 May 2025 21:01:37 +0000 https://help.easymorph.com/doku.php?id=transformations:cleanup&rev=1736547555&do=diff CLEAN UP Category: Transform / Basic Description This action removes specified values, or values of a particular type (e.g. text), from one or more columns by replacing them with empty cells. Use cases Clean Up is used for dealing with data quality issues - e.g. removing text values from columns where only numbers are expected, or removing specific undesired values. Most typically, anonymous@undisclosed.example.com (Anonymous) Fri, 10 Jan 2025 22:19:15 +0000 https://help.easymorph.com/doku.php?id=transformations:compare&rev=1738778315&do=diff COMPARE TABLES Category: Transform / Advanced Description This action compares two tables and produces a list of detected differences based on column metadata. Use cases Use this action to compare the current version of a dataset against an earlier one to determine if it has changed, and what those changes were. anonymous@undisclosed.example.com (Anonymous) Wed, 05 Feb 2025 17:58:35 +0000 https://help.easymorph.com/doku.php?id=transformations:concatenatetext&rev=1736551800&do=diff CONCATENATE TEXT Category: Transform / Basic Description This action concatenates the values in a column, separated by the chosen delimiter. Use cases * When a target system (exporting to) requires a value list in a single field. * Building a column that contains a list of tags. anonymous@undisclosed.example.com (Anonymous) Fri, 10 Jan 2025 23:30:00 +0000 https://help.easymorph.com/doku.php?id=transformations:constructhttpresponse&rev=1739040956&do=diff CONSTRUCT HTTP RESPONSE Category: Transform / Web Description This action constructs the fields required for an HTTP response of the EasyMorph API Server. A configured connection to an EasyMorph Server space is required. Use cases Create various responses the EasyMorph anonymous@undisclosed.example.com (Anonymous) Sat, 08 Feb 2025 18:55:56 +0000 https://help.easymorph.com/doku.php?id=transformations:constructjson&rev=1739231739&do=diff CONSTRUCT JSON Category: Transform / Web Description This action constructs a JSON object from a tabular dataset. It has two modes: Object per row, array from objects; and Array per column. A constructed JSON object is effectively a regular text value that is stored in a datagrid cell in EasyMorph. anonymous@undisclosed.example.com (Anonymous) Mon, 10 Feb 2025 23:55:39 +0000 https://help.easymorph.com/doku.php?id=transformations:convert&rev=1736978701&do=diff CONVERT DATA TYPE Category: Transform / Basic Description This action converts values of one type to another (Text to date, Text to number, Everything to text, Empty to text, or a number). Use cases * Convert text-based dates to numeric date values for use in date-based calculations downstream. anonymous@undisclosed.example.com (Anonymous) Wed, 15 Jan 2025 22:05:01 +0000 https://help.easymorph.com/doku.php?id=transformations:createbuckets&rev=1736981515&do=diff CREATE BUCKETS Category: Transform / Advanced Description Creates numerical ranges of fixed width and assigns each row to one of the ranges based on values in the specified column. Use cases The action is typically used for grouping number values (such as age or tenure) by intervals of fixed width (e.g. age group). Created group labels can later be used in reports and charts. anonymous@undisclosed.example.com (Anonymous) Wed, 15 Jan 2025 22:51:55 +0000 https://help.easymorph.com/doku.php?id=transformations:createlist&rev=1739121286&do=diff CREATE LIST Category: Create / Generate Description This action creates a 1-column list of up to 100 manually entered values. If several columns are required, the values can be entered separated by a delimiter (e.g. comma) and then split using the anonymous@undisclosed.example.com (Anonymous) Sun, 09 Feb 2025 17:14:46 +0000 https://help.easymorph.com/doku.php?id=transformations:crossmerge&rev=1736982296&do=diff CROSS MERGE Category: Transform / Advanced Description This action creates a table with all possible combinations (i.e. Cartesian product) of rows in two tables. Use cases Cross Merge can be helpful in a number of cases: * Generating a custom calendar anonymous@undisclosed.example.com (Anonymous) Wed, 15 Jan 2025 23:04:56 +0000 https://help.easymorph.com/doku.php?id=transformations:deduplicate&rev=1738552570&do=diff DEDUPLICATE ROWS Category: Transform / Filters Description This action removes all duplicate rows in the entire table. Deduplication can be performed based on all columns, or only on specific columns. Use cases Use this action to remove records that may have been duplicated in the source dataset or during previous actions, and keep unique records only. anonymous@undisclosed.example.com (Anonymous) Mon, 03 Feb 2025 03:16:10 +0000 https://help.easymorph.com/doku.php?id=transformations:deletedbrows&rev=1624258733&do=diff DELETE DATABASE ROWS Category: Workflow / External Description This action deletes rows from a database table where the filtering clause of the query is satisfied (i.e. the WHERE statement in the generated SQL). Column selections and other settings of the query are ignored. anonymous@undisclosed.example.com (Anonymous) Mon, 21 Jun 2021 06:58:53 +0000 https://help.easymorph.com/doku.php?id=transformations:deletedbrowsbykeys&rev=1626674559&do=diff DELETE MATCHING DATABASE ROWS Category: Workflow / External Description This action deletes rows in a database table where a combination of key fields matches a combination of key fields in the EasyMorph table. In the alternative mode, this action deletes rows where a combination of key fields anonymous@undisclosed.example.com (Anonymous) Mon, 19 Jul 2021 06:02:39 +0000 https://help.easymorph.com/doku.php?id=transformations:derive&rev=1758740824&do=diff DERIVE TABLE Category: Transform / Basic Description This transformation creates a derived table. anonymous@undisclosed.example.com (Anonymous) Wed, 24 Sep 2025 19:07:04 +0000 https://help.easymorph.com/doku.php?id=transformations:distributetotal&rev=1739128624&do=diff DISTRIBUTE TOTAL Category: Transform / Advanced Description This action breaks down a total/subtotal proportionally to a group of numbers (weights). Use cases Generate a projected set of values based on a historical breakdown applied to a projected total. anonymous@undisclosed.example.com (Anonymous) Sun, 09 Feb 2025 19:17:04 +0000 https://help.easymorph.com/doku.php?id=transformations:downloadfile&rev=1626363595&do=diff DOWNLOAD FILE Category: Workflow / External Description This action downloads a file over one of the following network protocols: HTTP, HTTPS, FTP, FTPS. It supports basic authentication with a login and password. Action settings Setting anonymous@undisclosed.example.com (Anonymous) Thu, 15 Jul 2021 15:39:55 +0000 https://help.easymorph.com/doku.php?id=transformations:dropboxcommand&rev=1740081926&do=diff DROPBOX COMMAND Category: Workflow / App/Cloud Description This action performs file and folder operations with Dropbox. A configured Dropbox connector is required. Capabilities * List files * Download file * Download list of files * Download folder anonymous@undisclosed.example.com (Anonymous) Thu, 20 Feb 2025 20:05:26 +0000 https://help.easymorph.com/doku.php?id=transformations:either&rev=1749849091&do=diff EITHER TABLE Category: Workflow / Internal Description Between two input datasets (the result of the previous action in the current table, and a final state of another table), Either table chooses the one that is not empty. If both tables are not empty, it gives preference based on the action settings. anonymous@undisclosed.example.com (Anonymous) Fri, 13 Jun 2025 21:11:31 +0000 https://help.easymorph.com/doku.php?id=transformations:emailcommand&rev=1755117630&do=diff EMAIL COMMAND Category: Workflow / External Description This action performs various operations on email messages. Capabilities * List folders * Mark as read * Mark as unread * Delete * Delete permanently * Move to folder Action settings anonymous@undisclosed.example.com (Anonymous) Wed, 13 Aug 2025 20:40:30 +0000 https://help.easymorph.com/doku.php?id=transformations:enumerate&rev=1736979681&do=diff ENUMERATE ROWS Category: Transform / Basic Description This action adds a new column with row numbers. Rows can be enumerated: for the entire table, inside groups (combinations of values), and to a specified value. Use cases * Create unique row IDs for datasets that do not already possess a unique key field. anonymous@undisclosed.example.com (Anonymous) Wed, 15 Jan 2025 22:21:21 +0000 https://help.easymorph.com/doku.php?id=transformations:enumerategroups&rev=1752688225&do=diff ENUMERATE GROUPS Category: Transform / Advanced Description This action generates group numbers in a new column. A "group" is defined by unique values in a column or unique combinations of values across multiple columns. Use cases This action can be used to create group ID numbers for later reference, lookups, or merges. anonymous@undisclosed.example.com (Anonymous) Wed, 16 Jul 2025 17:50:25 +0000 https://help.easymorph.com/doku.php?id=transformations:excelcommand&rev=1741367179&do=diff EXCEL COMMAND Category: Workflow / External Description This action performs commands on an Excel file. Capabilities * List sheets/ranges * Run VBA macro * Rename sheet * Delete sheet * Recalculate workbook * Re-save * Save as PDF anonymous@undisclosed.example.com (Anonymous) Fri, 07 Mar 2025 17:06:19 +0000 https://help.easymorph.com/doku.php?id=transformations:exclusiveaccess&rev=1634224736&do=diff START/FINISH EXCLUSIVE ACCESS Category: Workflow / Internal Description Enforce mutually exclusive access to a resource for simultaneously executed workflows (tasks). Use cases The action is intended for avoiding access conflicts when two or more simultaneously executed workflows (tasks) attempt to access a resource (e.g. write into a file or web anonymous@undisclosed.example.com (Anonymous) Thu, 14 Oct 2021 15:18:56 +0000 https://help.easymorph.com/doku.php?id=transformations:export1010data&rev=1534192714&do=diff Export into 1010data Exports dataset to 1010data using the tenup command-line utility (comes installed with EasyMorph). This action is experimental and is not fully supported. anonymous@undisclosed.example.com (Anonymous) Mon, 13 Aug 2018 20:38:34 +0000 https://help.easymorph.com/doku.php?id=transformations:exportairtable&rev=1621459385&do=diff EXPORT TO AIRTABLE Category: Export / App & Cloud Description This action exports (appends) a dataset into an Airtable table. Action settings Setting Description Connector*Select the pre-configured connector, or create a new connector, to the remote Airtable base. anonymous@undisclosed.example.com (Anonymous) Wed, 19 May 2021 21:23:05 +0000 https://help.easymorph.com/doku.php?id=transformations:exportapacheparquet&rev=1723611724&do=diff EXPORT TO APACHE PARQUET Category: Export / File Description This action exports the current dataset into an Apache Parquet (.parquet) file with metadata. Action settings Setting Description File*Enter fully-qualified filename to save the dataset to. anonymous@undisclosed.example.com (Anonymous) Wed, 14 Aug 2024 05:02:04 +0000 https://help.easymorph.com/doku.php?id=transformations:exportdataset&rev=1723900183&do=diff EXPORT DATASET (.dset) Category: Export / File Description This action exports a dataset (tabular data) into a file in the native EasyMorph format (.dset) that is stored either locally or on EasyMorph Server. The native format allows very fast writing as well as loading of the data into EasyMorph as there is no data conversion. anonymous@undisclosed.example.com (Anonymous) Sat, 17 Aug 2024 13:09:43 +0000 https://help.easymorph.com/doku.php?id=transformations:exportdb&rev=1697314828&do=diff EXPORT TO DATABASE Category: Export / Database Description This action exports the current dataset into a database table. The table must already exist. If the table doesn't exist it can be created using the Database command action prior to exporting data into it. anonymous@undisclosed.example.com (Anonymous) Sat, 14 Oct 2023 20:20:28 +0000 https://help.easymorph.com/doku.php?id=transformations:exportexcel&rev=1751128409&do=diff EXPORT INTO EXCEL FILE Category: Export / File Description This action exports the current dataset as a new Excel workbook (.xlsx) file, or into an existing Excel file, and supports the following modes: * Create new file * Create new sheet in existing file anonymous@undisclosed.example.com (Anonymous) Sat, 28 Jun 2025 16:33:29 +0000 https://help.easymorph.com/doku.php?id=transformations:exportgooglesheets&rev=1620614432&do=diff EXPORT GOOGLE SHEETS Category: Export / App & Cloud Description This action exports data from EasyMorph to Google Sheets. It can work in three modes: * Create a new spreadsheet * Create a new sheet in an existing spreadsheet * Replace data in an existing sheet within an existing spreadsheet anonymous@undisclosed.example.com (Anonymous) Mon, 10 May 2021 02:40:32 +0000 https://help.easymorph.com/doku.php?id=transformations:exportplaintext&rev=1678301999&do=diff EXPORT AS PLAIN TEXT Category: Export / File Description Export the contents of a column into a text file, as is. Each column value is exported as text into one line of the file. Use cases Most frequently, this action is used to create text files in a format not natively supported by EasyMorph. anonymous@undisclosed.example.com (Anonymous) Wed, 08 Mar 2023 18:59:59 +0000 https://help.easymorph.com/doku.php?id=transformations:exportpowerbi&rev=1620983734&do=diff EXPORT TO POWER BI Category: Export / App & Cloud Description This action appends rows to a push-dataset in the Power BI service. Both personal workspaces and shared workspaces are supported. Note that there are 3 types of datasets in Power BI: anonymous@undisclosed.example.com (Anonymous) Fri, 14 May 2021 09:15:34 +0000 https://help.easymorph.com/doku.php?id=transformations:exportqlikview&rev=1712895128&do=diff EXPORT INTO QLIK FILE Category: Export / File Description This action exports the current table into a Qlik .qvd file. Action settings Setting Description File* The fully-qualified file name of the output dataset (includes relative or absolute path). anonymous@undisclosed.example.com (Anonymous) Fri, 12 Apr 2024 04:12:08 +0000 https://help.easymorph.com/doku.php?id=transformations:exportsalesforce&rev=1635796055&do=diff EXPORT TO SALESFORCE Category: Export / App/Cloud Description This action exports rows from an EasyMorph dataset into a Salesforce object. Action settings Setting Description Connector* Select a configured Salesforce connector.Object1 anonymous@undisclosed.example.com (Anonymous) Mon, 01 Nov 2021 19:47:35 +0000 https://help.easymorph.com/doku.php?id=transformations:exportsharepointlist&rev=1675030533&do=diff EXPORT TO SHAREPOINT LIST Category: Export / App/Cloud Description This action appends records to a SharePoint list. Action settings Setting Description Connector * A configured connector to a SharePoint site. See SharePoint connector for details.List1Enter, or use the "Pick" button to select, the list to append to. (The Pick list will populate once the appropriate anonymous@undisclosed.example.com (Anonymous) Sun, 29 Jan 2023 22:15:33 +0000 https://help.easymorph.com/doku.php?id=transformations:exporttableau&rev=1620983438&do=diff EXPORT TO TABLEAU Category: Export / File, Export / App & Cloud Description This action exports the current table into a Tableau Hyper or Data Extract (.tde) file, or publishes to Tableau Server/Tableau Online. Action settings Setting anonymous@undisclosed.example.com (Anonymous) Fri, 14 May 2021 09:10:38 +0000 https://help.easymorph.com/doku.php?id=transformations:exporttext&rev=1626674929&do=diff EXPORT INTO DELIMITED TEXT FILE Category: Export / File Description This action exports a table into a delimited text file. The file name can use either a full or relative path. Use cases Create a plain-text, unformatted data file (such as CSV file) to exchange data with a wide variety of applications and services. anonymous@undisclosed.example.com (Anonymous) Mon, 19 Jul 2021 06:08:49 +0000 https://help.easymorph.com/doku.php?id=transformations:exportxml&rev=1751128791&do=diff EXPORT TO XML Category: Export / File Description Exports the current tabular dataset into an XML file. Action settings Setting Description File* The fully-qualified file name of the output dataset (includes relative or absolute path). anonymous@undisclosed.example.com (Anonymous) Sat, 28 Jun 2025 16:39:51 +0000 https://help.easymorph.com/doku.php?id=transformations:extractjson&rev=1738432800&do=diff EXTRACT JSON PROPERTIES Category: Transform / Web Description This action creates new columns with values from selected JSON properties contained within a single-cell text string typically received from an API call. Action settings Setting anonymous@undisclosed.example.com (Anonymous) Sat, 01 Feb 2025 18:00:00 +0000 https://help.easymorph.com/doku.php?id=transformations:fetchemail&rev=1624239813&do=diff FETCH EMAIL Category: Workflow / External Description This action retrieves emails from a mail server (IMAP or MS Exchange) and creates a table in which each line corresponds to one email message, and the columns contain various message attributes, such as sender, anonymous@undisclosed.example.com (Anonymous) Mon, 21 Jun 2021 01:43:33 +0000 https://help.easymorph.com/doku.php?id=transformations:filecommand&rev=1740080393&do=diff FILE COMMAND Category: Workflow / External Description This action performs various file operations. Capabilities * Copy/move file * Copy/move list of files * Rename/clone file * Rename list of files * Delete file * Delete list of files anonymous@undisclosed.example.com (Anonymous) Thu, 20 Feb 2025 19:39:53 +0000 https://help.easymorph.com/doku.php?id=transformations:filelist&rev=1739121208&do=diff LIST OF FILES Category: Create / Generate Description This action creates a table with a list of files in the specified folder and their attributes. Use cases Create a file list to be used later for iterations or file commands. Action settings anonymous@undisclosed.example.com (Anonymous) Sun, 09 Feb 2025 17:13:28 +0000 https://help.easymorph.com/doku.php?id=transformations:filesplitter&rev=1670189640&do=diff SPLIT DELIMITED FILE Category: Import / File Description This action aims to help in processing very large text files. It splits a text file into smaller chunks (which are also text files) that can further be processed using iterations. The chunks can be either of fixed length (by row count), or split by unique values of a column (e.g. one chunk per unique Date). anonymous@undisclosed.example.com (Anonymous) Sun, 04 Dec 2022 21:34:00 +0000 https://help.easymorph.com/doku.php?id=transformations:filetransfer&rev=1698925991&do=diff FILE TRANSFER Category: Workflow / External Description This action can perform various commands on files and folders on a remote server over an SSH connection using the SFTP or SCP protocol: * Upload file(s) * Download file(s) * List files anonymous@undisclosed.example.com (Anonymous) Thu, 02 Nov 2023 11:53:11 +0000 https://help.easymorph.com/doku.php?id=transformations:fillgaps&rev=1737652810&do=diff FILL DOWN Category: Transform / Advanced Description This action fills the empty cells in selected columns by duplicating the value of the last non-empty cell above the empty ones. The cells are filled downwards. Use cases To fill gaps that may be inherent in an imported outlined or hierarchical data structure. anonymous@undisclosed.example.com (Anonymous) Thu, 23 Jan 2025 17:20:10 +0000 https://help.easymorph.com/doku.php?id=transformations:fillright&rev=1748658547&do=diff FILL RIGHT Category: Transform / Advanced Description This action fills the empty cells across columns, within rows, by duplicating the value of the last non-empty cell to the left of the empty ones. The cells are filled rightward. Use cases anonymous@undisclosed.example.com (Anonymous) Sat, 31 May 2025 02:29:07 +0000 https://help.easymorph.com/doku.php?id=transformations:filter&rev=1737352649&do=diff FILTER BY CONDITION Category: Transform / Filters Description This action calculates an expression for every row and keeps only rows where this expression is TRUE. All other rows are removed. If no rows satisfy the condition then all rows are removed. anonymous@undisclosed.example.com (Anonymous) Mon, 20 Jan 2025 05:57:29 +0000 https://help.easymorph.com/doku.php?id=transformations:filterbytype&rev=1738159372&do=diff FILTER BY TYPE Category: Transform / Filters Description This action filters values depending on their data type. Filtering can be applied to several columns at once, as well as multiple data types. Use cases Filtering by type helps detect data quality issues by ensuring that columns in the exported dataset are strongly typed (i.e. all values in a column are of the same type). This might be required before exporting into a target system with strongly typed fields, such as a relation… anonymous@undisclosed.example.com (Anonymous) Wed, 29 Jan 2025 14:02:52 +0000 https://help.easymorph.com/doku.php?id=transformations:filterminmax&rev=1738160908&do=diff KEEP MIN/MAX Category: Transform / Filters Description This action keeps (or removes) only rows with the biggest or smallest values in a specified column. Use cases Use this action to generate datasets of "top N" or "bottom N" (or "top %" or "bottom %") records based on values in a specific column. anonymous@undisclosed.example.com (Anonymous) Wed, 29 Jan 2025 14:28:28 +0000 https://help.easymorph.com/doku.php?id=transformations:folderlist&rev=1739121142&do=diff LIST OF FOLDERS Category: Create / Generate Description This action creates a table with a list of folders in the specified folder. Use cases Such a table can be used later for iterations, folder commands, and/or file commands. Action settings anonymous@undisclosed.example.com (Anonymous) Sun, 09 Feb 2025 17:12:22 +0000 https://help.easymorph.com/doku.php?id=transformations:generatedocumentation&rev=1623985258&do=diff GENERATE PROJECT DOCUMENTATION Category: Workflow / External Description This action generates HTML documentation for an EasyMorph project. Use cases The documentation created by this action is useful for troubleshooting workflow issues as well as providing evidence of data sources being used, transformations that occur to the data during processing, and the final destination(s) of the data. anonymous@undisclosed.example.com (Anonymous) Fri, 18 Jun 2021 03:00:58 +0000 https://help.easymorph.com/doku.php?id=transformations:generatetext&rev=1740069237&do=diff GENERATE TEXT FROM TEMPLATE Description This action generates text by inserting parameters, field values, and external files into a text templates. Use cases Action settings Examples See also anonymous@undisclosed.example.com (Anonymous) Thu, 20 Feb 2025 16:33:57 +0000 https://help.easymorph.com/doku.php?id=transformations:generateuids&rev=1736986022&do=diff GENERATE UNIQUE IDENTIFIERS Category: Transform / Advanced Description This action creates a randomly generated 36-character global unique identifier (GUID) for each row in a table. Use cases * This action can be used to generate primary keys in tables. anonymous@undisclosed.example.com (Anonymous) Thu, 16 Jan 2025 00:07:02 +0000 https://help.easymorph.com/doku.php?id=transformations:googledrivecommand&rev=1750270849&do=diff GOOGLE DRIVE COMMAND Category: Workflow / App/Cloud Description This action performs file and folder operations with Google Drive. A configured Google Drive connector is required. Capabilities * List files * Download file * Download list of files * Download folder anonymous@undisclosed.example.com (Anonymous) Wed, 18 Jun 2025 18:20:49 +0000 https://help.easymorph.com/doku.php?id=transformations:group&rev=1737264066&do=diff GROUP Category: Transform / Advanced Description Replace multiple values with a single value (constant or calculated). Use cases * Creating flags that can later be used in expressions to handle the values within the group (set). This can be more convenient than using lengthy if..then..else statements to group a set of values. anonymous@undisclosed.example.com (Anonymous) Sun, 19 Jan 2025 05:21:06 +0000 https://help.easymorph.com/doku.php?id=transformations:halt&rev=1755116888&do=diff HALT/WARN ON CONDITION Category: Workflow / Internal Description This action can either abort project execution or display a warning and continue if the specified condition is not fulfilled. Use cases * Monitor data quality and prevent projects from producing incorrect results or exporting incorrect data. anonymous@undisclosed.example.com (Anonymous) Wed, 13 Aug 2025 20:28:08 +0000 https://help.easymorph.com/doku.php?id=transformations:haltontypemismatch&rev=1755116911&do=diff HALT ON DATA TYPE MISMATCH Category: Workflow / Internal Description This action halts project execution if a value from the specified column(s) has a wrong data type. Use cases The purpose of this action is to monitor data quality and prevent projects from producing incorrect results or exporting incorrect data. anonymous@undisclosed.example.com (Anonymous) Wed, 13 Aug 2025 20:28:31 +0000 https://help.easymorph.com/doku.php?id=transformations:hierarchypath&rev=1736995258&do=diff HIERARCHY PATH Category: Transform / Advanced Description This action generates a pipe-delimited hierarchy path for every value in a column that references a parent value in the same table. Use cases Use this action to build parent-child relationships such as company organizational charts. anonymous@undisclosed.example.com (Anonymous) Thu, 16 Jan 2025 02:40:58 +0000 https://help.easymorph.com/doku.php?id=transformations:importairtable&rev=1616955476&do=diff IMPORT FROM AIRTABLE Category: Import / App/Cloud Description This action connects to an Airtable database ("base") and retrieves data from a specified table via API Key and Base ID. Action settings Setting Description Connector*Select the pre-constructed connection to your Airtable base, or, build one by selecting anonymous@undisclosed.example.com (Anonymous) Sun, 28 Mar 2021 18:17:56 +0000 https://help.easymorph.com/doku.php?id=transformations:importapacheparquet&rev=1707106271&do=diff IMPORT FROM APACHE PARQUET (.parquet) Category: Import / File Description This action imports columns of data or key-value metadata from an Apache Parquet file (.parquet). Action settings Setting Description Load file* Enter or browse to the fully-qualified file name of the Parquet file (relative or absolute path). anonymous@undisclosed.example.com (Anonymous) Mon, 05 Feb 2024 04:11:11 +0000 https://help.easymorph.com/doku.php?id=transformations:importdataset&rev=1723610044&do=diff IMPORT DATASET (.dset) Category: Import / File Description This action imports a dataset (tabular data) from a file in the native EasyMorph format (.dset). This format allows very fast loading data into EasyMorph as there is no data conversion. anonymous@undisclosed.example.com (Anonymous) Wed, 14 Aug 2024 04:34:04 +0000 https://help.easymorph.com/doku.php?id=transformations:importexcel&rev=1747681804&do=diff IMPORT EXCEL SPREADSHEET Category: Import / File Description This action loads data from an Excel file. Supported formats: * .xlsx (Excel 2007 or later) * .xls (Excel 95 - Excel 2003) Action settings Setting Description Load file anonymous@undisclosed.example.com (Anonymous) Mon, 19 May 2025 19:10:04 +0000 https://help.easymorph.com/doku.php?id=transformations:importfixedwidthtext&rev=1738551993&do=diff IMPORT FIXED WIDTH TEXT Category: Import / File Description This action imports text files with columns of fixed width. The width and name of every column have to be defined explicitly in the transformation properties. Use the preview pane (click the anonymous@undisclosed.example.com (Anonymous) Mon, 03 Feb 2025 03:06:33 +0000 https://help.easymorph.com/doku.php?id=transformations:importgoogleanalytics&rev=1625466879&do=diff IMPORT FROM GOOGLE ANALYTICS Category: Import / App/Cloud Description This action imports metrics and dimensions from Google Analytics. A Google Analytics connector is required. Action settings Setting Description Connector* Select a configured Google Analytics connector. anonymous@undisclosed.example.com (Anonymous) Mon, 05 Jul 2021 06:34:39 +0000 https://help.easymorph.com/doku.php?id=transformations:importgooglesearchconsole&rev=1682026086&do=diff IMPORT FROM GOOGLE SEARCH CONSOLE Category: Import / App/Cloud Description This action retrieves metrics from the Google Search Console. A Google Search Console connector is required. Action settings Setting Description Connector*Select a configured Google Search Console connector. anonymous@undisclosed.example.com (Anonymous) Thu, 20 Apr 2023 21:28:06 +0000 https://help.easymorph.com/doku.php?id=transformations:importgooglesheets&rev=1682034717&do=diff IMPORT GOOGLE SHEETS Category: Import / App/Cloud Description Import data from a Google Sheets file. Action settings Setting Description Connector* A configured connector to Google Drive. See Google Drive connector. Spreadsheet* The path to the source Google Sheet document. This is set after the anonymous@undisclosed.example.com (Anonymous) Thu, 20 Apr 2023 23:51:57 +0000 https://help.easymorph.com/doku.php?id=transformations:importjira&rev=1707156471&do=diff IMPORT FROM JIRA Category: Import / App/Cloud Description This action imports various project and issue details from a Jira account. Action settings Setting Description Connector*Select a configured Jira connector. See Jira connector for details. anonymous@undisclosed.example.com (Anonymous) Mon, 05 Feb 2024 18:07:51 +0000 https://help.easymorph.com/doku.php?id=transformations:importjson&rev=1617939975&do=diff IMPORT JSON FROM FILE Category: Import / File Description Import a JSON object from a text file. Action settings Setting Description Load file* Fully-qualified file name of the dataset (includes relative or absolute path). Encoding anonymous@undisclosed.example.com (Anonymous) Fri, 09 Apr 2021 03:46:15 +0000 https://help.easymorph.com/doku.php?id=transformations:importmicrosoftdataverse&rev=1737842540&do=diff IMPORT FROM MICROSOFT DATAVERSE Category: Import / App/Cloud Description This action imports data and metadata from a Microsoft Dataverse environment. Action settings Setting Description Connector*Select a configured Microsoft Dataverse connector.CommandSelect the process to perform in the Dataverse environment. Options: anonymous@undisclosed.example.com (Anonymous) Sat, 25 Jan 2025 22:02:20 +0000 https://help.easymorph.com/doku.php?id=transformations:importodata&rev=1737938784&do=diff IMPORT FROM ODATA Category: Import / App/Cloud Description This action allows data to be imported from any OData provider. OData versions 3 and 4 are supported. Action settings Setting Description Connector*Select a configured Web Location connector or anonymous@undisclosed.example.com (Anonymous) Mon, 27 Jan 2025 00:46:24 +0000 https://help.easymorph.com/doku.php?id=transformations:importodbc&rev=1466378014&do=diff Import from ODBC Sends an free-form SQL query to an ODBC data source (user of system). The response is imported as a dataset. The query can use parameters in curly braces. Note: this transformation will be deprecated in future releases. Use Import from database transformation instead of it. anonymous@undisclosed.example.com (Anonymous) Sun, 19 Jun 2016 23:13:34 +0000 https://help.easymorph.com/doku.php?id=transformations:importpipedrive&rev=1625466312&do=diff IMPORT FROM PIPEDRIVE Category: Import / App/Cloud Description This action imports data from Pipedrive, such as deals, organizations, or persons. A configured Pipedrive connector is required. Action settings Setting Description Connector* Select a configured Pipedrive connector. anonymous@undisclosed.example.com (Anonymous) Mon, 05 Jul 2021 06:25:12 +0000 https://help.easymorph.com/doku.php?id=transformations:importplaintext&rev=1626203493&do=diff IMPORT PLAIN TEXT Category: Import / File Description Import a text file without parsing, as is, into a single column. Use cases Most frequently, the action is used to process text files in a format not natively supported by EasyMorph. anonymous@undisclosed.example.com (Anonymous) Tue, 13 Jul 2021 19:11:33 +0000 https://help.easymorph.com/doku.php?id=transformations:importpowerbi&rev=1737842739&do=diff IMPORT FROM POWER BI Category: Import / App/Cloud Description This action imports data from a Power BI semantic model. Action settings Setting Description Connector* Select a configured Microsoft PowerBI connector.Workspace*Check this on to select the Workspace the semantic model resides in. anonymous@undisclosed.example.com (Anonymous) Sat, 25 Jan 2025 22:05:39 +0000 https://help.easymorph.com/doku.php?id=transformations:importqlikview&rev=1712895102&do=diff IMPORT QLIK QVD FILE Category: Import / File Description This action loads data or metadata from a Qlik .qvd file. Action settings Setting Description Load file*Fully-qualified file name of the Qlik .qvd data file (includes relative or absolute path). anonymous@undisclosed.example.com (Anonymous) Fri, 12 Apr 2024 04:11:42 +0000 https://help.easymorph.com/doku.php?id=transformations:importsalesforce&rev=1635628699&do=diff IMPORT FROM SALESFORCE Category: Import / App/Cloud Description This action imports rows from a Salesforce object and, optionally, its child/parent objects. Action settings Setting Description Connector* Select a configured Salesforce connector. anonymous@undisclosed.example.com (Anonymous) Sat, 30 Oct 2021 21:18:19 +0000 https://help.easymorph.com/doku.php?id=transformations:importsas&rev=1617940010&do=diff IMPORT SAS FILE Category: Import / File Description This action imports a dataset from a .sas7bdat file. Column names can optionally be replaced with column labels (where available). Action settings Settings Description Load file* Fully-qualified file name of the dataset (includes relative or absolute path). anonymous@undisclosed.example.com (Anonymous) Fri, 09 Apr 2021 03:46:50 +0000 https://help.easymorph.com/doku.php?id=transformations:importsharepointlist&rev=1737842973&do=diff IMPORT SHAREPOINT LIST Category: Import / App/Cloud Description Imports a SharePoint list from a SharePoint site specified by a SharePoint connector. Action settings Setting Description Connector* A configured connector to a SharePoint site. See anonymous@undisclosed.example.com (Anonymous) Sat, 25 Jan 2025 22:09:33 +0000 https://help.easymorph.com/doku.php?id=transformations:importspss&rev=1617939299&do=diff IMPORT SPSS FILE Category: Import / File Description The transformation loads .sav files created in SPSS or PSPP. Both big endian and little endian notations are supported. There is an option to automatically replace values with value labels when they are available. anonymous@undisclosed.example.com (Anonymous) Fri, 09 Apr 2021 03:34:59 +0000 https://help.easymorph.com/doku.php?id=transformations:importsql&rev=1635284021&do=diff IMPORT FROM DATABASE Category: Import / Database Description This action imports data from a database specified by a connector. The query can be specified either using the visual Query Editor or as a SQL query loaded from an external file. anonymous@undisclosed.example.com (Anonymous) Tue, 26 Oct 2021 21:33:41 +0000 https://help.easymorph.com/doku.php?id=transformations:importtext&rev=1697071682&do=diff IMPORT DELIMITED TEXT FILE Category: Import / File Description This action loads data from one or multiple delimited text files. The number of columns in the resulting dataset is defined by the first row of imported data. Use cases Use the anonymous@undisclosed.example.com (Anonymous) Thu, 12 Oct 2023 00:48:02 +0000 https://help.easymorph.com/doku.php?id=transformations:importwebapi&rev=1749844092&do=diff IMPORT FROM WEB API Category: Import / App/Cloud Description This action sends a GET request to a web API and automatically parses the JSON/XML response into a tabular dataset. A configured Web Location connector is required. Use cases This action is intended for interactions with REST APIs, cloud applications, and websites. anonymous@undisclosed.example.com (Anonymous) Fri, 13 Jun 2025 19:48:12 +0000 https://help.easymorph.com/doku.php?id=transformations:importxml&rev=1628990880&do=diff IMPORT XML FILE Category: Import / File Description Import data from an XML file. Data elements are specified by an XML path. Optionally, data elements can be further narrowed down by selecting only particular XML elements and/or their attributes. Values and attributes of parent elements are repeated for child elements in order to preserve the relationship between them. anonymous@undisclosed.example.com (Anonymous) Sun, 15 Aug 2021 01:28:00 +0000 https://help.easymorph.com/doku.php?id=transformations:importzendesk&rev=1722312685&do=diff IMPORT FROM ZENDESK Category: Import / App/Cloud Description This action imports ticket and user data from Zendesk. Action settings Setting Description Connector* Select a configured Zendesk connector.Import actionChoose the type of data to import. Options: anonymous@undisclosed.example.com (Anonymous) Tue, 30 Jul 2024 04:11:25 +0000 https://help.easymorph.com/doku.php?id=transformations:incominghttprequest&rev=1677955782&do=diff INCOMING HTTP REQUEST Category: Import/ API Description This action receives an HTTP request from a custom API endpoint of EasyMorph Server. This action requires a configured connection to an EasyMorph Server space. Use cases When published to the EasyMorph Server, this action will receive incoming HTTP requests, capture the request information as a dataset, and populate the module's parameters with values passed in. Use the anonymous@undisclosed.example.com (Anonymous) Sat, 04 Mar 2023 18:49:42 +0000 https://help.easymorph.com/doku.php?id=transformations:incomingwebhooks&rev=1739918423&do=diff INCOMING WEBHOOKS Category: Import / API Description This action receives incoming webhook requests from EasyMorph Gateway. Use cases Action settings Examples See also anonymous@undisclosed.example.com (Anonymous) Tue, 18 Feb 2025 22:40:23 +0000 https://help.easymorph.com/doku.php?id=transformations:input&rev=1740840562&do=diff INPUT Category: Create / Input Description This action obtains an input dataset from the module (or project) that called the current module. If the current module was not called from another module (or project) then Input returns an empty dataset. This action works together with the following actions: anonymous@undisclosed.example.com (Anonymous) Sat, 01 Mar 2025 14:49:22 +0000 https://help.easymorph.com/doku.php?id=transformations:intervalmerge&rev=1737990817&do=diff INTERVAL MERGE Category: Transform / Advanced Description This action merges two tables based on whether a value in one table falls into a range specified by two values in another table. The lower boundary of a range is inclusive, the upper is exclusive. Ranges can overlap. In such cases, one row for each match will be inserted into the resulting table. anonymous@undisclosed.example.com (Anonymous) Mon, 27 Jan 2025 15:13:37 +0000 https://help.easymorph.com/doku.php?id=transformations:iterate&rev=1676414735&do=diff ITERATE Category: Workflow / Internal Description This action calls another project once for each row in a table. Parameters of the called project are assigned using the calling table's fields. Use cases Iterate is used to create "FOR…EACH" and "FOR…NEXT" types of loops within EasyMorph. anonymous@undisclosed.example.com (Anonymous) Tue, 14 Feb 2023 22:45:35 +0000 https://help.easymorph.com/doku.php?id=transformations:iteratecolumn&rev=1739151795&do=diff ITERATE COLUMN Category: Workflow / Internal Description Iteratively call another module or project and pass the columns of the input dataset to the called module/project, one column per iteration. The called module (or project) must have the anonymous@undisclosed.example.com (Anonymous) Mon, 10 Feb 2025 01:43:15 +0000 https://help.easymorph.com/doku.php?id=transformations:iterateprogram&rev=1755063197&do=diff ITERATE PROGRAM Category: Workflow / External Description This action runs the specified external application once for every line in the table. The action fails if the extеrnal application returns a non-zero exit code. Use cases * Run external applications (e.g. after a file is generated by EasyMorph) against a list of parameters generated in EasyMorph. anonymous@undisclosed.example.com (Anonymous) Wed, 13 Aug 2025 05:33:17 +0000 https://help.easymorph.com/doku.php?id=transformations:iteratetable&rev=1739151887&do=diff ITERATE TABLE Category: Workflow / Internal Description This action is similar to Iterate action but allows passing a table to an iterated project. Iterate table has two inputs: * The output of the previous action * The external table passed into the called module/project (referenced in the Action settings) anonymous@undisclosed.example.com (Anonymous) Mon, 10 Feb 2025 01:44:47 +0000 https://help.easymorph.com/doku.php?id=transformations:iteratewebrequest&rev=1698926876&do=diff ITERATE WEB REQUEST Category: Workflow / External Description This action sends multiple uniform HTTP requests to a web server. Requests are configured using values from columns of the input dataset. One request is sent for each line of the input dataset. Responses can be automatically appended into one dataset or saved as files into a designated folder. This action requires a configured Web Location connector. anonymous@undisclosed.example.com (Anonymous) Thu, 02 Nov 2023 12:07:56 +0000 https://help.easymorph.com/doku.php?id=transformations:jiracommand&rev=1740082678&do=diff JIRA COMMAND Category: Workflow / App/Cloud Description This action performs commands on project issues within a Jira account. Capabilities * Create issue * Change issue status * Delete issue Action settings Setting Description anonymous@undisclosed.example.com (Anonymous) Thu, 20 Feb 2025 20:17:58 +0000 https://help.easymorph.com/doku.php?id=transformations:keepdifferent&rev=1435111810&do=diff Keep Mismatching This transformation only keeps rows where values in the specified column are missing in the specified column of another table. EXAMPLE Table 1: Average income and deductions Country Gross income Disposable income Compulsory deductions anonymous@undisclosed.example.com (Anonymous) Wed, 24 Jun 2015 02:10:10 +0000 https://help.easymorph.com/doku.php?id=transformations:keepduplicates&rev=1737501229&do=diff KEEP DUPLICATES Category: Transform / Filters Description This action keeps all duplicate rows and removes all unique rows. This operation can be performed on all columns, or only on specific columns. In the latter case, the uniqueness of values in columns not selected will be ignored. anonymous@undisclosed.example.com (Anonymous) Tue, 21 Jan 2025 23:13:49 +0000 https://help.easymorph.com/doku.php?id=transformations:keepexisting&rev=1435111853&do=diff Keep Matching This transformation only keeps rows where values in the specified column exist in the specified column of another table. EXAMPLE Table 1: Average income and deductions Country Gross income Disposable income Compulsory deductions anonymous@undisclosed.example.com (Anonymous) Wed, 24 Jun 2015 02:10:53 +0000 https://help.easymorph.com/doku.php?id=transformations:keepremovecolumns&rev=1748711338&do=diff KEEP/REMOVE COLUMNS Category: Transform / Basic Description This action keeps or removes selected columns. Several columns can be kept or removed within a single action. The action's icon will depict whether this action is in "Keep" or "Remove" mode. anonymous@undisclosed.example.com (Anonymous) Sat, 31 May 2025 17:08:58 +0000 https://help.easymorph.com/doku.php?id=transformations:keepremovematching&rev=1748711473&do=diff KEEP/REMOVE MATCHING Category: Transform / Filters Description This action keeps or removes rows where values in the specified column match the specified column of another table. Use cases * Finding the difference between two lists, or the overlapping records of two lists. anonymous@undisclosed.example.com (Anonymous) Sat, 31 May 2025 17:11:13 +0000 https://help.easymorph.com/doku.php?id=transformations:labelcolumns&rev=1737839891&do=diff LABEL COLUMNS Category: Transform / Advanced Description This action creates column names using one or more top rows in the dataset. Use cases This action can be used to parse data in spreadsheets with multi-line column headers. Import spreadsheets anonymous@undisclosed.example.com (Anonymous) Sat, 25 Jan 2025 21:18:11 +0000 https://help.easymorph.com/doku.php?id=transformations:linearregression&rev=1740694556&do=diff LINEAR REGRESSION Category: Transform / Math Description This action calculates the simple linear regression for a series of values. Action settings SettingDescriptionCategorySelect the category column.SeriesSelect the series column.Mode anonymous@undisclosed.example.com (Anonymous) Thu, 27 Feb 2025 22:15:56 +0000 https://help.easymorph.com/doku.php?id=transformations:lookup&rev=1738373397&do=diff LOOKUP Category: Transform / Basic Description This action looks up values from a specified column in another table and if found, a return value from the same row but a different column of that table. Use cases * Used to replace common misspellings with the correct value. anonymous@undisclosed.example.com (Anonymous) Sat, 01 Feb 2025 01:29:57 +0000 https://help.easymorph.com/doku.php?id=transformations:lookuprename&rev=1738374854&do=diff RENAME COLUMNS WITH LOOKUP Category: Transform / Advanced Description This action renames columns in a table by looking up old and new column names in another table. The lookup table should have 2 columns: one containing the old names, and one listing the new names. anonymous@undisclosed.example.com (Anonymous) Sat, 01 Feb 2025 01:54:14 +0000 https://help.easymorph.com/doku.php?id=transformations:makedatetimecolumns&rev=1736726690&do=diff MAKE DATE/TIME COLUMNS Category: Transform / Advanced Description Take a column with dates and/or times and produce one or more columns of various components (e.g. year, weekday, hour, minutes, etc.) of the original dates or time period names. anonymous@undisclosed.example.com (Anonymous) Mon, 13 Jan 2025 00:04:50 +0000 https://help.easymorph.com/doku.php?id=transformations:massreplace&rev=1738549956&do=diff TABLE-WIDE REPLACE Category: Transform / Advanced Description This action performs the same replacement in all or selected columns. Use cases * Use this action to correct dataset-wide misspellings. * Expand abbreviations into full text, or abbreviate full text values. anonymous@undisclosed.example.com (Anonymous) Mon, 03 Feb 2025 02:32:36 +0000 https://help.easymorph.com/doku.php?id=transformations:match&rev=1739230887&do=diff MATCH Category: Transform / Advanced Description This action goes through text values in the source table and finds matching values in a second "lookup" table (lookup table). Matched lookup values then replace original values. Use cases anonymous@undisclosed.example.com (Anonymous) Mon, 10 Feb 2025 23:41:27 +0000 https://help.easymorph.com/doku.php?id=transformations:merge&rev=1736802706&do=diff MERGE ANOTHER TABLE Category: Transform / Basic Description This action appends one or more columns from another table where the values in certain columns in both tables match. The action is similar to the SQL join, with four modes: Lookup, Left Join, Full Join, and Inner Join. anonymous@undisclosed.example.com (Anonymous) Mon, 13 Jan 2025 21:11:46 +0000 https://help.easymorph.com/doku.php?id=transformations:metadata&rev=1736739494&do=diff TABLE METADATA Category: Transform / Advanced Description This action obtains various metadata of the current dataset. Use cases * Obtaining column names can be helpful in determining whether a column exists, or is missing, in a table. anonymous@undisclosed.example.com (Anonymous) Mon, 13 Jan 2025 03:38:14 +0000 https://help.easymorph.com/doku.php?id=transformations:modifycolumnnames&rev=1738243254&do=diff MODIFY COLUMN NAMES Category: Transform / Basic Description This action adds prefixes and/or suffixes to existing column names. Use cases * This action can be used to distinguish columns merged from another table. * Use this action to distinguish datasets' columns prior to merging, when the datasets contain columns with similar names. anonymous@undisclosed.example.com (Anonymous) Thu, 30 Jan 2025 13:20:54 +0000 https://help.easymorph.com/doku.php?id=transformations:modifyjson&rev=1738751946&do=diff MODIFY JSON Category: Transform / Web Description This action modifies aspects of a JSON object. Commands this action can run are: Change property value, Add property, Delete property, Rename property, and Reformat JSON. Action settings Setting anonymous@undisclosed.example.com (Anonymous) Wed, 05 Feb 2025 10:39:06 +0000 https://help.easymorph.com/doku.php?id=transformations:morphservercommand&rev=1740082199&do=diff EASYMORPH SERVER COMMAND Category: Workflow / App/Cloud Description This action allows interaction with a remote EasyMorph Server using a configured EasyMorph Server connector. Capabilities * Run task * Enable/disable task * Upload file anonymous@undisclosed.example.com (Anonymous) Thu, 20 Feb 2025 20:09:59 +0000 https://help.easymorph.com/doku.php?id=transformations:naturalmerge&rev=1737275563&do=diff NATURAL MERGE Category: Transform / Advanced Description This action merges two tables based on columns with the same name. Use cases Use this action to auto-merge two tables without having to manually select specific columns. Action settings anonymous@undisclosed.example.com (Anonymous) Sun, 19 Jan 2025 08:32:43 +0000 https://help.easymorph.com/doku.php?id=transformations:onedrivecommand&rev=1740083037&do=diff ONEDRIVE COMMAND Category: Workflow / App/Cloud Description This action performs file and folder operations with OneDrive. A configured OneDrive connector is required. Capabilities * List files * Download file * Download list of files * Download folder anonymous@undisclosed.example.com (Anonymous) Thu, 20 Feb 2025 20:23:57 +0000 https://help.easymorph.com/doku.php?id=transformations:parametertable&rev=1739121966&do=diff PARAMETER TABLE Category: Create / Generate Description This action creates a single-row dataset where each column displays a project parameter name and value. Each column corresponds to one parameter. Use cases * Parameter table is a convenient way to start processing input values passed into the project by another project during iterations. anonymous@undisclosed.example.com (Anonymous) Sun, 09 Feb 2025 17:26:06 +0000 https://help.easymorph.com/doku.php?id=transformations:parseformsubmission&rev=1738437401&do=diff PARSE WEB FORM SUBMISSION Category: Transform / Web Description Parse data in the "x-www-form-urlencoded" format, which is a typical result of a web form submission on a web page. Action settings SettingDescription Column The column containing the web-form data to be parsed. anonymous@undisclosed.example.com (Anonymous) Sat, 01 Feb 2025 19:16:41 +0000 https://help.easymorph.com/doku.php?id=transformations:parsejson&rev=1738892937&do=diff PARSE JSON Category: Transform / Web Description Parse text values that are JSON objects into a tabular dataset. Action settings SettingDescription Column The column containing the source JSON to be parsed. JSON Path* The path to the JSON node from which parsing starts. anonymous@undisclosed.example.com (Anonymous) Fri, 07 Feb 2025 01:48:57 +0000 https://help.easymorph.com/doku.php?id=transformations:parsexml&rev=1738438603&do=diff PARSE XML Category: Transform / Web Description Parse XML data into a tabular format. Use cases * Enterprise data parsing from enterprise systems (e.g., transactions, messages). * Parse data from Web APIs that return XML. Action settings anonymous@undisclosed.example.com (Anonymous) Sat, 01 Feb 2025 19:36:43 +0000 https://help.easymorph.com/doku.php?id=transformations:peek&rev=1736526309&do=diff PEEK Category: Transform / Basic Description This action takes a value from another table and creates a new column populated with this value. Use cases A typical use case for this action would be bringing in a total value from another table for further calculation - such as % from the total. anonymous@undisclosed.example.com (Anonymous) Fri, 10 Jan 2025 16:25:09 +0000 https://help.easymorph.com/doku.php?id=transformations:pivot&rev=1746479907&do=diff PIVOT Category: Transform / Advanced Description Creates a matrix table from a straight table using values in one column as the column labels, and values in a second column as the matrix columns' values. This action is opposite to Unpivot. Use cases anonymous@undisclosed.example.com (Anonymous) Mon, 05 May 2025 21:18:27 +0000 https://help.easymorph.com/doku.php?id=transformations:play&rev=1664219526&do=diff PLAY SOUND Category: Workflow / Internal Description This action plays a system sound or .wav audio file. Use cases To alert the user when a situation has occurred, like the completion of a workflow run or an error. Action settings anonymous@undisclosed.example.com (Anonymous) Mon, 26 Sep 2022 19:12:06 +0000 https://help.easymorph.com/doku.php?id=transformations:powerbicommand&rev=1740485068&do=diff POWER BI COMMAND Category: Workflow / App/Cloud Description This action triggers an action in the Power BI Service remotely. A configured Power BI connector is required. Capabilities * List workspaces * List datasets * Refresh dataset * Delete all table rows anonymous@undisclosed.example.com (Anonymous) Tue, 25 Feb 2025 12:04:28 +0000 https://help.easymorph.com/doku.php?id=transformations:powershell&rev=1626553594&do=diff POWERSHELL Category: Workflow / External Description This action allows executing PowerShell commands and scripts from within EasyMorph. PowerShell 3.0 or above is required. Use cases PowerShell is a very versatile scripting language supported by the vast ecosystem of the .NET framework. Having EasyMorph integrated with Powershell opens access to a large number of PowerShell cmdlets which help automate various tasks (e.g. advanced file operations, sending emails, computer management,… anonymous@undisclosed.example.com (Anonymous) Sat, 17 Jul 2021 20:26:34 +0000 https://help.easymorph.com/doku.php?id=transformations:projectmetadata&rev=1689817871&do=diff PROJECT METADATA Category: Import / File Description Generate lists of various EasyMorph (.morph) project metadata: * Connectors used in a project's actions * Parameters * Modules * Groups * Tables * Actions (with connector names, and parameter names, when applicable) anonymous@undisclosed.example.com (Anonymous) Thu, 20 Jul 2023 01:51:11 +0000 https://help.easymorph.com/doku.php?id=transformations:qlikcloudcommand&rev=1740485204&do=diff QLIK CLOUD COMMAND Category: Workflow / App/Cloud Description This action performs a Qlik Cloud command such as uploading a file or reloading an app. A configured Qlik Cloud connector is required. Capabilities * List applications * Reload application * anonymous@undisclosed.example.com (Anonymous) Tue, 25 Feb 2025 12:06:44 +0000 https://help.easymorph.com/doku.php?id=transformations:qliksensecommand&rev=1740084287&do=diff QLIK SENSE COMMAND Category: Workflow / App/Cloud Description This action triggers synchronous reloading of the specified task in QMC (Qlik Sense Management Console) and waits until the task is finished. If the task fails, the QMC task reload errors are returned as EasyMorph errors (EasyMorph parses the task log under the hood). A configured anonymous@undisclosed.example.com (Anonymous) Thu, 20 Feb 2025 20:44:47 +0000 https://help.easymorph.com/doku.php?id=transformations:raiseissue&rev=1742328780&do=diff RAISE ISSUE Category: Workflow / Internal Description This action creates a new issue in an Explorer board in EasyMorph Server. Action settings Setting Description Board* Select the Board on an EasyMorph Server to raise the issue on. anonymous@undisclosed.example.com (Anonymous) Tue, 18 Mar 2025 20:13:00 +0000 https://help.easymorph.com/doku.php?id=transformations:regexp&rev=1737348669&do=diff REGULAR EXPRESSION Category: Transform / Advanced Description This action creates a column with values that match a pattern specified using a regular expression. Use cases * A Regular Expression ("RegEx") is typically used to match values based on patterns or combinations of characters, numbers, symbols, and spaces that common "find" or "replace" functions (which use static values with wildcard characters) can't work with. anonymous@undisclosed.example.com (Anonymous) Mon, 20 Jan 2025 04:51:09 +0000 https://help.easymorph.com/doku.php?id=transformations:remove&rev=1428694116&do=diff Remove Columns This transformation removes selected columns. Several columns can be removed in one transformation. EXAMPLE Source table: The longest rivers in the world River Length (km) Length (miles) Continent Nile 6650 4132 anonymous@undisclosed.example.com (Anonymous) Fri, 10 Apr 2015 19:28:36 +0000 https://help.easymorph.com/doku.php?id=transformations:removeemptycolumns&rev=1736727167&do=diff REMOVE EMPTY COLUMNS Category: Transform / Advanced Description This action removes columns with little or no meaningful information. It can remove columns where: all values are empty, all values are empty or whitespace, or, all values are the same. anonymous@undisclosed.example.com (Anonymous) Mon, 13 Jan 2025 00:12:47 +0000 https://help.easymorph.com/doku.php?id=transformations:removeemptyrows&rev=1736727777&do=diff REMOVE EMPTY ROWS Category: Transform / Advanced Description This action removes empty rows or rows that appear empty, and have no meaningful information (e.g. whitespace values). For convenience, certain columns can be ignored if they have non-empty values which are not necessary. anonymous@undisclosed.example.com (Anonymous) Mon, 13 Jan 2025 00:22:57 +0000 https://help.easymorph.com/doku.php?id=transformations:rename&rev=1737840245&do=diff RENAME COLUMNS Category: Transform / Basic Description This action changes the name of one or more columns. Duplicating names are not permitted. Use cases * Align column names with another table prior to merging. * Apply column names to tables imported without headings. anonymous@undisclosed.example.com (Anonymous) Sat, 25 Jan 2025 21:24:05 +0000 https://help.easymorph.com/doku.php?id=transformations:reorder&rev=1736634768&do=diff REORDER COLUMNS Category: Transform / Basic Description Move one or more columns in the table to the leftmost position, to the rightmost position, or after a particular column. Use cases * Group columns together * Ensure a particular order of columns before exporting to a file anonymous@undisclosed.example.com (Anonymous) Sat, 11 Jan 2025 22:32:48 +0000 https://help.easymorph.com/doku.php?id=transformations:repeat&rev=1733209190&do=diff REPEAT Category: Workflow / Internal Description The Repeat action allows for arranging "DO…WHILE" and "DO…UNTIL" types of loops. It repeatedly calls a module (or another project) until/while its result table is not empty, or empty, depending on the settings. anonymous@undisclosed.example.com (Anonymous) Tue, 03 Dec 2024 06:59:50 +0000 https://help.easymorph.com/doku.php?id=transformations:repeatrows&rev=1738000744&do=diff REPEAT ROWS Category: Transform / Advanced Description This action repeats each row as many times as specified in a given column. In the output dataset, the selected column will contain an enumeration of the rows from 1 to n (the number of times the row is repeated). anonymous@undisclosed.example.com (Anonymous) Mon, 27 Jan 2025 17:59:04 +0000 https://help.easymorph.com/doku.php?id=transformations:replace&rev=1736551615&do=diff REPLACE Category: Transform / Basic Description This action replaces particular values in a column with new values. The new values can be either text or numbers. Multiple old values can be replaced with the same new value. Use cases * anonymous@undisclosed.example.com (Anonymous) Fri, 10 Jan 2025 23:26:55 +0000 https://help.easymorph.com/doku.php?id=transformations:replacecolumns&rev=1736887723&do=diff MODIFY COLUMN(S) Category: Transform / Basic Description This action calculates and replaces the values in one or more existing columns using expression(s). Each expression replaces one column. Use cases * Apply standardized abbreviations to full-length text values (or full-length values to abbreviations). anonymous@undisclosed.example.com (Anonymous) Tue, 14 Jan 2025 20:48:43 +0000 https://help.easymorph.com/doku.php?id=transformations:replacewithlookup&rev=1738001883&do=diff REPLACE WITH LOOKUP Category: Transform / Advanced Description This action replaces substrings in one or more columns using a lookup table. Use cases * Used to replace common misspellings with the correct values. * Used to replace abbreviations with the full values. anonymous@undisclosed.example.com (Anonymous) Mon, 27 Jan 2025 18:18:03 +0000 https://help.easymorph.com/doku.php?id=transformations:retrievecatalogitem&rev=1737656530&do=diff RETRIEVE CATALOG ASSET Category: Import / App/Cloud Description This action retrieves a static or computed item (dataset, file, or URL) from the Data Catalog. Action settings Setting Description RetrieveSelect the asset type to be retrieved. Options: anonymous@undisclosed.example.com (Anonymous) Thu, 23 Jan 2025 18:22:10 +0000 https://help.easymorph.com/doku.php?id=transformations:rollup&rev=1738076555&do=diff ROLL UP Category: Transform / Advanced Description This action adds amounts up through each level of a hierarchy structure. Use cases Generate total (summed) values for each level of a hierarchy (i.e., accounting/chart of accounts, employee hierarchy structure, etc.) anonymous@undisclosed.example.com (Anonymous) Tue, 28 Jan 2025 15:02:35 +0000 https://help.easymorph.com/doku.php?id=transformations:rule&rev=1736803685&do=diff RULE Category: Transform / Basic Description This action calculates a new column or replaces an existing column, by using one or several ordered IF...THEN...ELSE conditions. The conditions are checked one by one until a satisfying condition is found. When found, the result is calculated and all other conditions are ignored. When no satisfying condition is found, the default calculation is applied. anonymous@undisclosed.example.com (Anonymous) Mon, 13 Jan 2025 21:28:05 +0000 https://help.easymorph.com/doku.php?id=transformations:runningtotal&rev=1736742951&do=diff RUNNING TOTAL Category: Transform / Advanced Description This action calculates rank (ascending and descending), cumulative count, sum, or % from the total sum for a given column inside groups, or table-wide. Use cases * Calculate a running total of sales by time period (weekly, monthly, or annually). anonymous@undisclosed.example.com (Anonymous) Mon, 13 Jan 2025 04:35:51 +0000 https://help.easymorph.com/doku.php?id=transformations:runprogram&rev=1755063164&do=diff RUN PROGRAM Category: Workflow / External Description This action runs a specified external application and waits until it finishes. If no external application is provided the command line is executed by the Windows shell (cmd.exe). The action fails if the extеrnal application returns a non-zero exit code. anonymous@undisclosed.example.com (Anonymous) Wed, 13 Aug 2025 05:32:44 +0000 https://help.easymorph.com/doku.php?id=transformations:salesforcecommand&rev=1697073830&do=diff UPDATE/DELETE RECORDS IN SALESFORCE Category: Workflow / External Description This action updates or deletes rows in a Salesforce object. Action settings Setting Description Connector* Select a configured Salesforce connector.Object@Enter, or use the "Pick" button to browse through and select, the Salesforce object to export data to. anonymous@undisclosed.example.com (Anonymous) Thu, 12 Oct 2023 01:23:50 +0000 https://help.easymorph.com/doku.php?id=transformations:sandbox&rev=1739226297&do=diff SANDBOX Category: Create / Input Description This action creates a temporary table that is typically used for one-time calculations. Sandboxes can be populated with result data of any action, or pasted from the clipboard. Use cases Besides ad hoc calculations, sandboxes can be used in a few more cases: anonymous@undisclosed.example.com (Anonymous) Mon, 10 Feb 2025 22:24:57 +0000 https://help.easymorph.com/doku.php?id=transformations:sanitize&rev=1736740569&do=diff SANITIZE TEXT Category: Transform / Advanced Description This action removes "invisible" characters from text values that are frequently unwanted because they may lead to mismatches and wrong merges: * Hidden system characters * Tabs * anonymous@undisclosed.example.com (Anonymous) Mon, 13 Jan 2025 03:56:09 +0000 https://help.easymorph.com/doku.php?id=transformations:searchfilter&rev=1737354487&do=diff FILTER BY SEARCH Category: Transform / Filters Description This action keeps or removes rows where values in a specified column contain a particular substring or match a regular expression. Use cases * Create subsets of a dataset based on parts of values in a specific column (literal strings or regular expressions). anonymous@undisclosed.example.com (Anonymous) Mon, 20 Jan 2025 06:28:07 +0000 https://help.easymorph.com/doku.php?id=transformations:select&rev=1428694164&do=diff Select Columns This transformation removes all columns except the selected ones. EXAMPLE Source table: The longest rivers in the world River Length (km) Length (miles) Continent Nile 6650 4132 Africa Amazon 6400 3976 anonymous@undisclosed.example.com (Anonymous) Fri, 10 Apr 2015 19:29:24 +0000 https://help.easymorph.com/doku.php?id=transformations:selectbylookup&rev=1738078271&do=diff SELECT COLUMNS BY LOOKUP Category: Transform / Advanced Description This action selects (keeps) columns whose names are listed in another table. Use cases This action is typically used when the names of columns to select are not known in advance and have to be obtained dynamically during a calculation. anonymous@undisclosed.example.com (Anonymous) Tue, 28 Jan 2025 15:31:11 +0000 https://help.easymorph.com/doku.php?id=transformations:selectdbrowsbykeys&rev=1731510834&do=diff SELECT MATCHING DATABASE ROWS Category: Import / Database Description Selects rows from a database table where a combination of key fields matches a combination of key fields in an EasyMorph table. Use cases This action can be used for anonymous@undisclosed.example.com (Anonymous) Wed, 13 Nov 2024 15:13:54 +0000 https://help.easymorph.com/doku.php?id=transformations:selectionfilter&rev=1738158328&do=diff FILTER Category: Transform / Filters Description This action filters a dataset based on selected values in a specified column. The action can be set to either keep the rows or remove them. Use cases * Create subsets of a dataset based on values in a specific column. anonymous@undisclosed.example.com (Anonymous) Wed, 29 Jan 2025 13:45:28 +0000 https://help.easymorph.com/doku.php?id=transformations:sendemail&rev=1626368065&do=diff SEND EMAIL Category: Workflow / External Description This action sends an email to one or multiple recipients. Optionally, it can be configured to attach a file, or insert an HTML table. Use cases Automate the sending of processed results to the recipient automatically as an attached file or embedded anonymous@undisclosed.example.com (Anonymous) Thu, 15 Jul 2021 16:54:25 +0000 https://help.easymorph.com/doku.php?id=transformations:sendntfymessage&rev=1740084400&do=diff SEND A MESSAGE TO NTFY Category: Workflow / App/Cloud Description This action sends messages to the ntfy open-source messaging application. Use cases This action can be used to send various notifications and metrics to mobile devices or alert when an event happens (e.g. a metric has exceeded a threshold). anonymous@undisclosed.example.com (Anonymous) Thu, 20 Feb 2025 20:46:40 +0000 https://help.easymorph.com/doku.php?id=transformations:sendpushovermessage&rev=1712893189&do=diff SEND MESSAGE TO PUSHOVER Category: Workflow / App/Cloud Description This action sends a text message through the Pushover service to a mobile device. Use cases This action can be used to send various notifications and metrics to mobile devices, or alert when an event happened (e.g. a metric has exceeded a threshold). anonymous@undisclosed.example.com (Anonymous) Fri, 12 Apr 2024 03:39:49 +0000 https://help.easymorph.com/doku.php?id=transformations:sequence&rev=1739120992&do=diff SEQUENCE Category: Create / Generate Description This action creates a table with a sequence of integer numbers starting from 1. Use cases A Sequence table can be used later for creating loops (iterations). Action settings Setting anonymous@undisclosed.example.com (Anonymous) Sun, 09 Feb 2025 17:09:52 +0000 https://help.easymorph.com/doku.php?id=transformations:sharedmemory&rev=1742333638&do=diff SHARED MEMORY Category: Workflow / Internal Description This action can perform the following operations with the shared memory (details below): * Remember a value by a key * Forget a value and its associated key * Recall a list of keys anonymous@undisclosed.example.com (Anonymous) Tue, 18 Mar 2025 21:33:58 +0000 https://help.easymorph.com/doku.php?id=transformations:sharepointcommand&rev=1751128686&do=diff SHAREPOINT COMMAND Category: Workflow / App/Cloud Description This action performs file operations with a SharePoint site. A configured SharePoint connector is required. SharePoint Online and on-premises SharePoint sites are supported. Capabilities * List files anonymous@undisclosed.example.com (Anonymous) Sat, 28 Jun 2025 16:38:06 +0000 https://help.easymorph.com/doku.php?id=transformations:sharepointlistcommand&rev=1675030812&do=diff UPDATE/DELETE ROWS IN SHAREPOINT LIST Category: Workflow / External Description This action updates or deletes rows in a SharePoint list. Action settings Setting Description Connector * A configured connector to a SharePoint site. See anonymous@undisclosed.example.com (Anonymous) Sun, 29 Jan 2023 22:20:12 +0000 https://help.easymorph.com/doku.php?id=transformations:shiftcolumn&rev=1736741235&do=diff SHIFT COLUMN UP/DOWN Category: Transform / Advanced Description This action shifts values in the specified column up or down. When a column is shifted down, empty cells are inserted at the top of the column. When shifted up, empty cells are inserted at the bottom. anonymous@undisclosed.example.com (Anonymous) Mon, 13 Jan 2025 04:07:15 +0000 https://help.easymorph.com/doku.php?id=transformations:skipifunchanged&rev=1755116514&do=diff SKIP IF UNCHANGED Category: Workflow / Internal Description This action skips the rest of the actions in the table if the current dataset did not change since the previous workflow run. Use cases * Provides a simplified way to detect dataset changes when a workflow is triggered by a Server trigger or by a Launcher task. anonymous@undisclosed.example.com (Anonymous) Wed, 13 Aug 2025 20:21:54 +0000 https://help.easymorph.com/doku.php?id=transformations:skiponcondition&rev=1755116641&do=diff SKIP ACTIONS ON CONDITION Category: Workflow / Internal Description This action skips the next action or the rest of the actions in the table if the specified condition is not fulfilled. Use cases Provides a simpler way to arrange conditional workflows by avoiding unnecessary actions based on a condition. anonymous@undisclosed.example.com (Anonymous) Wed, 13 Aug 2025 20:24:01 +0000 https://help.easymorph.com/doku.php?id=transformations:skiponconditioninanothertable&rev=1755116577&do=diff SKIP ON CONDITION IN ANOTHER TABLE Category: Workflow / Internal Description This action skips the next action or the rest of the actions in the table if the specified condition in another table is not fulfilled. Use cases This action provides a cleaner way to design conditional workflows where the data used to calculate a condition is separated from the main dataset. anonymous@undisclosed.example.com (Anonymous) Wed, 13 Aug 2025 20:22:57 +0000 https://help.easymorph.com/doku.php?id=transformations:slackbot&rev=1712885411&do=diff SLACK BOT Category: Workflow / App/Cloud Description This action allows sending plain as well as richly formatted notifications to Slack. Action settings Setting Description Connector*Select or create a configured Slack Bot connector. anonymous@undisclosed.example.com (Anonymous) Fri, 12 Apr 2024 01:30:11 +0000 https://help.easymorph.com/doku.php?id=transformations:slidingaggregation&rev=1738079552&do=diff SLIDING AGGREGATION Category: Transform / Advanced Description This action calculates an aggregate, such as average, of N sliding values. Available aggregations are: Average, Sum, Min, Max, Count Distinct. Use cases This action can be used for adding smoothed trendlines to charts. anonymous@undisclosed.example.com (Anonymous) Tue, 28 Jan 2025 15:52:32 +0000 https://help.easymorph.com/doku.php?id=transformations:sort&rev=1736551657&do=diff SORT Category: Transform / Basic Description This action sorts the table by one or more columns in ascending or descending order. The order of the columns matters. Use cases * To find the least/greatest amounts in a column. (numeric) * anonymous@undisclosed.example.com (Anonymous) Fri, 10 Jan 2025 23:27:37 +0000 https://help.easymorph.com/doku.php?id=transformations:splitdelimitedtext&rev=1738079738&do=diff SPLIT DELIMITED TEXT INTO COLUMNS Category: Transform / Advanced Description This action splits text values that are separated by delimiting characters into multiple columns. Use cases Use this action on any text-based data files using non-standard delimiters (e.g. pipe, tilde) that Easymorph doesn't automatically detect, and imports all values into a single column. anonymous@undisclosed.example.com (Anonymous) Tue, 28 Jan 2025 15:55:38 +0000 https://help.easymorph.com/doku.php?id=transformations:splitfixedwidthtext&rev=1737319044&do=diff SPLIT FIXED WIDTH TEXT Category: Transform / Advanced Description This action splits text values of the selected column into multiple columns of values of specified lengths. It is similar to the Import fixed width text action with the difference being that it works with the already loaded dataset. anonymous@undisclosed.example.com (Anonymous) Sun, 19 Jan 2025 20:37:24 +0000 https://help.easymorph.com/doku.php?id=transformations:splitjsonarray&rev=1738893227&do=diff SPLIT JSON ARRAY Category: Transform / Web Description This action splits a JSON array into rows. Action settings Setting Description ColumnSelect the column that contains the JSON array structure to split. Examples Example #1 "Split the following JSON array into individual rows. anonymous@undisclosed.example.com (Anonymous) Fri, 07 Feb 2025 01:53:47 +0000 https://help.easymorph.com/doku.php?id=transformations:spreadsheetmetadata&rev=1626368163&do=diff SPREADSHEET METADATA Category: Import / File Description This action creates a list of sheet names, range names, or both, in a spreadsheet (.xls or .xlsx) file. Use cases The Spreadsheet metadata action can be convenient for extracting sheet and range names to pass down the workflow to reference specific parts of the Excel file: anonymous@undisclosed.example.com (Anonymous) Thu, 15 Jul 2021 16:56:03 +0000 https://help.easymorph.com/doku.php?id=transformations:sqlcommand&rev=1740076808&do=diff DATABASE COMMAND Category: Workflow / External Description This action performs commands on a specified database. Capabilities * Custom command * Create database table * Delete database table * Delete all rows * List tables * anonymous@undisclosed.example.com (Anonymous) Thu, 20 Feb 2025 18:40:08 +0000 https://help.easymorph.com/doku.php?id=transformations:sshcommand&rev=1625366797&do=diff SSH COMMAND Category: Workflow / External Description This action connects to a remote computer using SSH and executes one or more specified commands in the same SSH session. The commands can have EasyMorph parameters inserted, or entirely calculated using expressions. anonymous@undisclosed.example.com (Anonymous) Sun, 04 Jul 2021 02:46:37 +0000 https://help.easymorph.com/doku.php?id=transformations:start&rev=1755111190&do=diff Actions All the actions available in EasyMorph: Import / File * Import dataset - import dataset from a file in the native EasyMorph data format (.dset). * Import delimited text file - import data from a delimited text files (e.g. .csv). * Import Excel spreadsheet - import data from Excel spreadsheets (.xls,.xlsx). anonymous@undisclosed.example.com (Anonymous) Wed, 13 Aug 2025 18:53:10 +0000 https://help.easymorph.com/doku.php?id=transformations:statisticalaggregation&rev=1737319563&do=diff STATISTICAL AGGREGATION Category: Transform / Advanced Description This action generates one or more statistical calculations: Median, Percentile, Standard deviation, Standard error, and Variance. Action settings SettingDescriptionColumn anonymous@undisclosed.example.com (Anonymous) Sun, 19 Jan 2025 20:46:03 +0000 https://help.easymorph.com/doku.php?id=transformations:status&rev=1626580554&do=diff STATUS Category: Workflow / Internal Description This action updates project execution status with a custom message (which can be calculated using an expression). It serves the same purpose, but works differently, in EasyMorph Desktop, Launcher, and EasyMorph Server (see section Remarks below). anonymous@undisclosed.example.com (Anonymous) Sun, 18 Jul 2021 03:55:54 +0000 https://help.easymorph.com/doku.php?id=transformations:subfield&rev=1738079882&do=diff SPLIT DELIMITED TEXT INTO ROWS Category: Transform / Advanced Description This action splits column values delimited with a separator (e.g. comma) into multiple rows -- one row per value. Values in other columns are duplicated in the new rows. anonymous@undisclosed.example.com (Anonymous) Tue, 28 Jan 2025 15:58:02 +0000 https://help.easymorph.com/doku.php?id=transformations:subtotal&rev=1738155244&do=diff TOTAL/SUBTOTALS Category: Transform / Advanced Description This action appends to a dataset a new column that contains an aggregated value for the selected column, or for groupings in that column. The aggregation options are: Sum, Count, Average, Min, or Max. anonymous@undisclosed.example.com (Anonymous) Wed, 29 Jan 2025 12:54:04 +0000 https://help.easymorph.com/doku.php?id=transformations:synchronize&rev=1626580741&do=diff SYNCHRONIZE Category: Workflow / Internal Description This action pauses the current action chain until the last action of another table is calculated. Use cases This action is usually used for synchronization of access to external files and applications in order to avoid simultaneous reading/writing by independent action chains. In a typical use case, it is inserted immediately before a side-effect action (export, run program, etc.). As EasyMorph calculates independent action chai… anonymous@undisclosed.example.com (Anonymous) Sun, 18 Jul 2021 03:59:01 +0000 https://help.easymorph.com/doku.php?id=transformations:systeminformation&rev=1739123134&do=diff SYSTEM INFORMATION Category: Create / Generate Description This action generates a single-row dataset of system information items such as: Windows account name (of the current Windows process), Windows identity (of the user that triggered the workflow), Free RAM (in anonymous@undisclosed.example.com (Anonymous) Sun, 09 Feb 2025 17:45:34 +0000 https://help.easymorph.com/doku.php?id=transformations:tableaucommand&rev=1740084741&do=diff TABLEAU SERVER COMMAND Category: Workflow / App/Cloud Description This action remotely triggers various actions in Tableau Server / Online. A configured Tableau Server connector or Tableau Online connector is required. Capabilities * Run extract refresh task * Run flow asynchronously anonymous@undisclosed.example.com (Anonymous) Thu, 20 Feb 2025 20:52:21 +0000 https://help.easymorph.com/doku.php?id=transformations:teamsbot&rev=1712885573&do=diff TEAMS BOT Category: Workflow / App/Cloud Description This action sends notifications to channels in Microsoft Teams. Note: Messages can be either plain text or Adaptive Cards (which can be richly formatted and contain hyperlinks, images, buttons, bulleted lists, and much more.) anonymous@undisclosed.example.com (Anonymous) Fri, 12 Apr 2024 01:32:53 +0000 https://help.easymorph.com/doku.php?id=transformations:todo&rev=1689817486&do=diff TO-DO Category: Workflow / Internal Description This action adds a "to-do" item to the workflow which may optionally be assigned to someone to review, and/or a due date. This action has no effect on the workflow, itself. Use cases This action is designed to aid in the organization and collaboration of workflow development by introducing to-do "notes" into the workflow that can bring attention to proposed workflow edits, algorithm concepts, introduce sample data, etc. at the position… anonymous@undisclosed.example.com (Anonymous) Thu, 20 Jul 2023 01:44:46 +0000 https://help.easymorph.com/doku.php?id=transformations:trimbycondition&rev=1738378661&do=diff TRIM TABLE BY CONDITION Category: Transform / Filters Description This action removes the rows above or below the first row where the specific condition is true. Use cases * Remove records that occurred before or after a specific date. * Remove records of system events that happened before an error occurred, keeping the events that happened anonymous@undisclosed.example.com (Anonymous) Sat, 01 Feb 2025 02:57:41 +0000 https://help.easymorph.com/doku.php?id=transformations:trimtable&rev=1737508531&do=diff TRIM TABLE Category: Transform / Filters Description This action keeps or removes the first or last N rows. Use cases * Keep only the top N significant items (e.g. top 10 products by sales volume) for a report or dashboard. * Reduce the size of a larger dataset to a specific number of rows during the initial build of a workflow. Remove or disable the anonymous@undisclosed.example.com (Anonymous) Wed, 22 Jan 2025 01:15:31 +0000 https://help.easymorph.com/doku.php?id=transformations:unpivot&rev=1737094688&do=diff UNPIVOT Category: Transform / Advanced Description Converts a matrix table into a straight table by rotating columns into "Labels" and "Data" columns. This action is opposite to the Pivot action. Use cases This action is used to convert a cross-table (or matrix) into a straight table. It can be used, for instance, to convert a cross-table from an Excel spreadsheet into a table suitable for exporting into a database. anonymous@undisclosed.example.com (Anonymous) Fri, 17 Jan 2025 06:18:08 +0000 https://help.easymorph.com/doku.php?id=transformations:updatedb&rev=1697418337&do=diff UPDATE DATABASE TABLE Category: Workflow / External Description This action updates a database table with data from EasyMorph. Action settings Setting Description Connector*Select or create a connector to the database. * Setting can be specified using a anonymous@undisclosed.example.com (Anonymous) Mon, 16 Oct 2023 01:05:37 +0000 https://help.easymorph.com/doku.php?id=transformations:uploadedfiles&rev=1737916291&do=diff UPLOADED FILES Category: Create / Input Description This action lists all files uploaded using the File upload parameters in the current workflow. Action settings No settings are required for this action. This action creates a list of files, uploaded via one or more anonymous@undisclosed.example.com (Anonymous) Sun, 26 Jan 2025 18:31:31 +0000 https://help.easymorph.com/doku.php?id=transformations:verify&rev=1738557265&do=diff VERIFY DATA IN ANOTHER TABLE Category: Transform / Advanced Description This action verifies the quality of data in another table and can accumulate verification results. Use cases * Multiple Verify actions can be chained together to create data validation pipelines that perform various checks on the same dataset. anonymous@undisclosed.example.com (Anonymous) Mon, 03 Feb 2025 04:34:25 +0000 https://help.easymorph.com/doku.php?id=transformations:wait&rev=1749849802&do=diff WAIT Category: Workflow / Internal Description This action pauses the action chain for a specified number of seconds. No actions are performed during this wait time. This action doesn't block or pause independent action chains in the project. anonymous@undisclosed.example.com (Anonymous) Fri, 13 Jun 2025 21:23:22 +0000 https://help.easymorph.com/doku.php?id=transformations:webrequest&rev=1749844049&do=diff WEB REQUEST Category: Workflow / External Description This action sends a single HTTP request to a web server and receives a response. A configured Web Location connector is required. Supports all HTTP methods - GET, POST, PUT, DELETE, HEAD, OPTIONS, CONNECT, TRACE, PATCH. anonymous@undisclosed.example.com (Anonymous) Fri, 13 Jun 2025 19:47:29 +0000 https://help.easymorph.com/doku.php?id=transformations:xslt&rev=1751128584&do=diff XSLT TRANSFORMATION Category: Workflow / External Description This action is intended for the modification of XML files and converting them into text files using XSLT (Extensible Stylesheet Language Transformations). The action applies XSL stylesheets directly to the target file. The current in-memory dataset is not affected. anonymous@undisclosed.example.com (Anonymous) Sat, 28 Jun 2025 16:36:24 +0000 https://help.easymorph.com/doku.php?id=transformations:zendeskcommand&rev=1740084880&do=diff ZENDESK COMMAND Category: Workflow / App/Cloud Description This action performs Zendesk commands such as create or delete tickets. Capabilities * Create ticket * Update ticket * Delete ticket Action settings Setting Description anonymous@undisclosed.example.com (Anonymous) Thu, 20 Feb 2025 20:54:40 +0000