transformations:start
This is an old revision of the document!
Table of Contents
Actions
List of all 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 fixed width text file -import tabular data with fixed width columns from text file
- Import from database - import data from a database
- Import Qlik file - import data from a QVD file
- Import SAS file - import data from a SAS file (.sas7bdat)
- Import SPSS file - import data from a SPSS/PSPP file (.sav)
- Import XML file - import data from an XML file
- Select matching database rows - import rows from a database table where key values match (or don't match) key values in EasyMorph table.
- Split delimited text file - split large file into smaller chunks without loading it into EasyMorph
- Spreadsheet metadata - create a list with names of all sheets in a spreadsheet
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.
- Merge another table - merge (join) one or more columns from another table where certain columns in both tables match.
- Modify column - replace existing column with a calculated expression.
- Peek - create a new column using a single value from another table.
- 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
- 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.
- Pivot - create a matrix table.
- Regular expression - create a new column with regular expression matches.
- Rename columns with lookup - rename multiple columns using a lookup table.
- Running total - calculate rank, cumulative count, sum or % from total sum.
- 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 mismatching - keep rows with values that don't exist in another table.
- Keep matching - keep rows with values that exist in another table.
- Trim table - keep/remove top/bottom N rows.
- Trim table by condition - keep/remove rows above/below first row matching condition.
Export
- 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 QlikView file - export data into a QlikView QVD file.
- Export into 1010data - export into 1010data (experimental, not supported).
- Export into Tableau - export data into a Tableau Data Extract.
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
- 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.
- File command - performs basic file operations such as copy/move/rename/delete/unzip.
- Iterate external program - execute external application once for each row in table.
- PowerShell - executes one or more PowerShell statements.
- Qlik Sense command - execute a Qlik Sense command remotely..
- Run external program - execute external application once.
- Send email - send an email with attachment to one or more recipients.
- Tableau Server command - trigger extract refresh on a Tableau Server.
- XSLT - transform given XML file using XSLT stylesheets.
transformations/start.1530394263.txt.gz · Last modified: 2018/06/30 17:31 by dmitry