User Tools

Site Tools


transformations:start

This is an old revision of the document!


Actions

All the actions available in EasyMorph:

Import / File

Import / Database

Import / App & Cloud

Create / Generate

  • Calendar - create a sequence of dates in specified date range
  • Create list - create a list of up to 100 manually entered values
  • List of files - create a list of files in specified folder
  • List of folders - create a list of folders in specified folder
  • Parameter table - creates a single-row table with parameter values as columns
  • Sequence - generate a sequence of numbers from 1 to N

Create / Input

  • Input - obtain input dataset from a calling project
  • Sandbox - create a table with temporary static snapshot of data

Transform / Basic

  • Aggregate - calculate aggregates (subtotals) like sum or count grouped by one or more fields.
  • Append another table - Append another table as new rows or columns.
  • Calculate new column(s) - calculate new column with expression built using arithmetical operations and various functions.
  • Clean up - remove particular values from a column.
  • Convert data type - convert text dates into number dates.
  • Enumerate rows - add column with row numbers.
  • Keep/remove columns - retain or delete selected columns.
  • Lookup - replace values in a column using a lookup table.
  • Merge another table - merge (join) one or more columns from another table where certain columns in both tables match.
  • Modify column(s) - replace existing column with a calculated expression.
  • Peek - create a new column using a single value from another table.
  • Rename columns - assign new names to selected columns.
  • Reorder columns - rearrange the sequence of the columns within a dataset.
  • Replace - replace particular values in a column with new ones.
  • Rule - calculate or replace a column using multiple nested IF..THEN…ELSE conditions.
  • Sort - sort table by one or more columns.

Transform / Advanced

Transform / Filters

Transform / Math

  • Distribute total - Break down a total/subtotal proportionally to a group of numbers (weights).
  • Linear regression - Build a linear regression. Interpolate/extrapolate values if needed.
  • Running total - Calculate rank, cumulative count, sum or % from total sum.
  • Statistical aggregation - Calculate median, percentile, standard error, standard deviation, or variance.
  • Total/subtotals - add column total or group subtotals as a new column.

Export / File

Export / Database

Export / App & Cloud

Workflow / Internal

  • Call another module/project - pass table data to another project and run it once.
  • Either table - between current table and another table choose one that is not empty.
  • Halt on condition - abort project execution if the specified condition is fulfilled.
  • Halt on data type mismatch - abort project execution if a value in specified column(s) has a wrong type.
  • Iterate - run another module/project once for each row in table.
  • Iterate column - run another module/project once for each column in table and automatically append all returned columns into one table.
  • Iterate table - run another module/project once for each row in table and pass another table to it.
  • Repeat - run another module/project until/while its output is empty.
  • Shared memory - perform operations on shared memory, a key-value data respository.
  • Skip actions on condition - skip the rest of action in table if the specified condition is fulfilled.
  • Start/finish exclusive access - enforce mutually exclusive access to a resource for simultaneously executed projects (tasks).
  • Status - display custom project execution status message.
  • Synchronize - wait until another table is calculated.
  • Wait - pause execution for specified number of seconds.

Workflow / External

  • Database command - create/delete/truncate DB table or send a custom SQL command to a database (e.g. to bulk load a file).
  • Delete database rows - delete rows in a database table that satisfy query condition.
  • Delete matching database rows - delete rows in a database table where key values match/don't match key values in an EasyMorph table.
  • Download file - download a file from the internet.
  • Excel command - perform file/sheet operations and run VBA macros in Excel files.
  • Fetch email - fetch email messages and their attachments from a mail server (Exchange or IMAP).
  • File command - performs basic file operations such as copy/move/rename/delete/unzip.
  • File transfer - transfer files over SFTP or SCP to or from a remote computer.
  • Generate project documentation - generate HTML documentation for an EasyMorph project.
  • Iterate program - execute external application once for each row in table.
  • Iterate Web Request - send multiple uniform HTTP requests to a web API and append responses into one table.
  • PowerShell - executes one or more PowerShell statements.
  • Run program - execute external application once.
  • Send email - send an email with attachment to one or more recipients.
  • SSH command - run one or several commands on a remote computer using the SSH protocol.
  • Update database table - update a database table with values from EasyMorph.
  • Web Request - send an HTTP request to a web API and receive a response.
  • XSLT - transform given XML file using XSLT stylesheets.

Workflow / Apps and cloud

:?: If you need an action that is not currently available in EasyMorph please feel free to make a feature request on the Community forum.

transformations/start.1636773756.txt.gz · Last modified: 2021/11/12 22:22 by craigt

Donate Powered by PHP Valid HTML5 Valid CSS Driven by DokuWiki