User Tools

Site Tools


transformations:start

This is an old revision of the document!


Actions

List of all actions available in EasyMorph:

Import

Create

  • Calendar - create a sequence of dates in specified date range
  • Create List - create a list of up to 100 manually entered values
  • File List - create a list of files in specified folder
  • Folder List - create a list of folders in specified folder
  • Parameter table - creates a single-row table with parameter values as columns
  • Sequence - generate a sequence of numbers from 1 to N
  • Input - obtain input dataset from a calling project
  • Sandbox - create a table with temporary static snapshot of data

Transform / Basic

Transform / Advanced

Transform / Filters

Export

Workflow / Internal

  • Call - pass table data to another project and run it once.
  • Either table - between current table and another table choose one that is not empty.
  • Halt on condition - stop project execution with an error if a condition is TRUE for any row.
  • Iterate - run another EasyMorph project once for each row in table.
  • Status - display custom project execution status message.
  • Synchronize with another table - wait until another table is calculated.
  • Wait - pause execution for specified number of seconds.

Workflow / External

  • Amazon command - perform an operation with AWS S3 , e.g. upload/download a file.
  • Database command - create/delete/truncate DB table or send a custom SQL command to a database (e.g. to bulk load a file).
  • Delete database rows - delete rows in a database table that satisfy query condition.
  • Delete matching database rows - delete rows in a database table where key values match (or don't match) key values in EasyMorph table.
  • Download file - download a file from the internet.
  • EasyMorph Server command - Trigger a task, or upload/download/delete a file on a remote EasyMorph Server.
  • Fetch email - fetch email messages and their attachments from a mail server (Exchange or IMAP).
  • File command - performs basic file operations such as copy/move/rename/delete/unzip.
  • File transfer - transfer files over SFTP or SCP to or from a remote computer.
  • Google Drive command - perform an operation with Google Drive, e.g. download a file.
  • Iterate external program - execute external application once for each row in table.
  • 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.
  • Qlik Sense command - execute a Qlik Sense command remotely.
  • Run external program - execute external application once.
  • Send email - send an email with attachment to one or more recipients.
  • SharePoint Command - transfer file(s) to/from SharePoint.
  • SSH command - run one or several commands on a remote computer using the SSH protocol.
  • Tableau Server command - trigger extract refresh on a Tableau Server.
  • Web Request - send an HTTP request to a web API and receive a response.
  • XSLT - transform given XML file using XSLT stylesheets.
transformations/start.1570553208.txt.gz · Last modified: 2019/10/08 12:46 by dmitry

Donate Powered by PHP Valid HTML5 Valid CSS Driven by DokuWiki