transformations:start
This is an old revision of the document!
Table of Contents
Actions
All the actions available in EasyMorph:
Import
- Import delimited text file - import data from a delimited text files (e.g. CSV).
- Import Excel file - import data from Excel spreadsheets (.xls,.xlsx).
- Import dataset - import dataset from a file in the native EasyMorph data format (.dset).
- Import fixed width text file -import tabular data with fixed width columns from text file.
- Import from database - import data from a database.
- Import from Google Sheets - import data from a Google Sheets spreadsheet.
- Import Qlik file - import data from a QVD file.
- Import SAS file - import data from a SAS file (.sas7bdat).
- Import SharePoint list - import a SharePoint list.
- Import SPSS file - import data from a SPSS/PSPP file (.sav).
- Import XML file - import data from an XML file.
- Project metadata - project metadata such as list of connectors or parameters.
- Select matching database rows - import rows from a database table where key values match (or don't match) key values in EasyMorph table.
- Split delimited text file - split large file into smaller chunks without loading it into EasyMorph.
- Spreadsheet metadata - create a list with names of all sheets in a spreadsheet.
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
- Aggregate - calculate aggregates (subtotals) like sum or count grouped by one or more fields.
- Append another table - Append another table as new rows or columns.
- Calculate new column - calculate new column with expression built using arithmetical operations and various functions.
- Clean up - remove particular values from a column.
- Convert data type - convert text dates into number dates.
- Enumerate rows - add column with row numbers.
- Lookup - replace values in a column using a lookup table.
- Make date/time columns - Create column(s) with date/time attributes derived from a date column.
- Merge another table - merge (join) one or more columns from another table where certain columns in both tables match.
- Repeat rows - repeat each row as many times as specified in given column.
- Modify column - replace existing column with a calculated expression.
- Peek - create a new column using a single value from another table.
- 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.
- Total/subtotals - add column total or group subtotals as a new column.
Transform / Advanced
- Construct JSON - Construct a JSON object.
- Create buckets - Create ranges of fixed width and assign each row to one of the ranges.
- Cross merge - Create a table with all possible combinations (i.e. Cartesian product) of rows in two tables.
- Enumerate Groups - Enumerate all combinations of values in given columns.
- Fill down - Fill down empty cells.
- Fill right - Fill empty cells to the right.
- Group - Assign a group name (or flag) to selected column values.
- Interval merge - Merge columns from another table where key values fall into an interval defined by two columns.
- Label columns - Name columns using values from top rows.
- Match - Find text strings in another table, that are contained in the current table.
- Parse JSON - Parse a JSON object into a tabular dataset.
- Pivot - Create a matrix table by pivoting.
- Regular expression - Create a new column with regular expression matches.
- Remove empty columns - Remove columns where all values are the same or empty.
- Remove empty rows - Remove rows where all values are empty or whitespace.
- Rename columns with lookup - Rename multiple columns using a lookup table.
- Running total - Calculate rank, cumulative count, sum or % from total sum.
- Sanitize - Remove hidden system characters, extra spaces, and line breaks.
- Select columns by lookup - Select columns using a lookup table.
- Shift column up/down - Shifts column values up or down.
- Split delimited text into columns - Split delimited values of a column into new columns.
- Split delimited text into rows - Split delimited values of a column into rows.
- Split fixed width text - Split a column with fixed width text values into new columns.
- Table metadata - Obtain column names, total row count and other table metadata.
- Table-wide replace - Remove or replace values across selected columns.
- Unpivot - Convert a matrix table into a straight table.
Transform / Filters
- Deduplicate rows - remove duplicate rows in entire table based on all or selected columns.
- Filter - filter rows by selecting/deselecting column values.
- Filter by condition - filter rows that satisfy expression.
- Filter by search - filter rows that contain (or don't contain) search string.
- Filter by type - keep or remove only rows with values of particular data type (e.g. errors).
- Keep duplicates - keep only duplicate rows based on all or selected columns.
- Keep min/max - keep/remove rows with the top N biggest/smallest values.
- Keep/remove matching - keep or remove rows with values that exist in another table.
- Trim table - keep/remove top/bottom N rows.
- Trim table by condition - keep/remove rows above/below first row matching condition.
Transform / Math
- Linear regression - Build a linear regression. Interpolate/extrapolate values if needed.
- Statistical aggregation - Calculate median, percentile, standard error, standard deviation, or variance.
Export
- Bulk export into database - bulk export into database table (SQL Server only).
- Export into database - export EasyMorph table into database table.
- Export into delimited text file - export data into CSV or another delimited text format.
- Export into Excel spreadsheet - export data into an Excel spreadsheet.
- Export into Google Sheets - export data into a Google Sheets spreadsheet.
- Export dataset - export dataset into a file in the native EasyMorph data format (.dset).
- Export to Power BI dataset - export to Power BI push-dataset.
- Export into Qlik file - export data into a Qlik QVD file.
- Export into Tableau - export data into a Tableau TDE/Hyper file or publish to Tableau Server/Online.
- Export into XML file - export data into an XML file.
- Update database table - update a database table with values from EasyMorph.
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 - 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 columns - 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
- Skip on condition - skip the rest of action in table if the specified condition is fulfilled.
- 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.
- Power BI Command - Trigger a Power BI action, such as refreshing a dataset.
- 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.
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.1607298829.txt.gz · Last modified: 2020/12/06 18:53 by dmitry