Both sides previous revisionPrevious revisionNext revision | Previous revisionNext revisionBoth sides next revision |
transformations:start [2018/06/30 17:34] – [Transform / Basic] dmitry | transformations:start [2019/04/29 19:15] – [Export] dmitry |
---|
* [[transformations:importtext|Import delimited text file]] - import data from a delimited text files (e.g. CSV) | * [[transformations:importtext|Import delimited text file]] - import data from a delimited text files (e.g. CSV) |
* [[transformations:importexcel|Import Excel file]] - import data from Excel spreadsheets (.xls,.xlsx) | * [[transformations:importexcel|Import Excel file]] - import data from Excel spreadsheets (.xls,.xlsx) |
| * [[transformations:importdataset|Import dataset]] - import dataset from a file in the native EasyMorph data format (.dset). |
* [[transformations:importfixedwidthtext|Import fixed width text file]] -import tabular data with fixed width columns from text file | * [[transformations:importfixedwidthtext|Import fixed width text file]] -import tabular data with fixed width columns from text file |
* [[transformations:importsql|Import from database]] - import data from a database | * [[transformations:importsql|Import from database]] - import data from a database |
| * [[transformations:importgooglesheet|Import Google Sheet]] - import data from a Google Sheet spreadsheet |
* [[transformations:importqlikview|Import Qlik file]] - import data from a QVD file | * [[transformations:importqlikview|Import Qlik file]] - import data from a QVD file |
* [[transformations:importsas|Import SAS file]] - import data from a SAS file (.sas7bdat) | * [[transformations:importsas|Import SAS file]] - import data from a SAS file (.sas7bdat) |
| |
==== Transform / Advanced ==== | ==== Transform / Advanced ==== |
* [[transformations:fillgaps|Fill down]] - fill down empty cells. | * [[transformations:crossmerge|Cross merge]] - Create a table with all possible combinations (i.e. Cartesian product) of rows in two tables. |
* [[transformations:fillright|Fill right]] - fill empty cells to the right. | * [[transformations:fillgaps|Fill down]] - Fill down empty cells. |
| * [[transformations:fillright|Fill right]] - Fill empty cells to the right. |
* [[transformations:generateuids|Generate UIDs]] | * [[transformations:generateuids|Generate UIDs]] |
* [[transformations:group|Group]] - assign a group name (or flag) to selected column values. | * [[transformations:group|Group]] - Assign a group name (or flag) to selected column values. |
* [[transformations:intervalmerge|Interval merge]] - Merge columns from another table where key values fall into an interval defined by two columns. | * [[transformations:intervalmerge|Interval merge]] - Merge columns from another table where key values fall into an interval defined by two columns. |
* [[transformations:labelcolumns|Label columns]] - name columns using values from top rows. | * [[transformations:labelcolumns|Label columns]] - Name columns using values from top rows. |
* [[transformations:match|Match]] - Find text strings in another table, that are contained in the current table. | * [[transformations:match|Match]] - Find text strings in another table, that are contained in the current table. |
* [[transformations:pivot|Pivot]] - Create a matrix table by pivoting. | * [[transformations:pivot|Pivot]] - Create a matrix table by pivoting. |
* [[transformations:regexp|Regular expression]] - Create a new column with regular expression matches. | * [[transformations:regexp|Regular expression]] - Create a new column with regular expression matches. |
| * [[transformations:removeemptycolumns|Remove empty columns]] - Remove columns where all values are the same or empty. |
| * [[transformations:removeemptyrows|Remove empty rows]] - Remove rows where all values are empty or whitespace. |
* [[transformations:lookuprename|Rename columns with lookup]] - Rename multiple columns using a lookup table. | * [[transformations:lookuprename|Rename columns with lookup]] - Rename multiple columns using a lookup table. |
* [[transformations:runningtotal|Running total]] - Calculate rank, cumulative count, sum or % from total sum. | * [[transformations:runningtotal|Running total]] - Calculate rank, cumulative count, sum or % from total sum. |
* [[transformations:selectbylookup|Select columns by lookup]] - Select columns using a lookup table. | * [[transformations:selectbylookup|Select columns by lookup]] - Select columns using a lookup table. |
* [[transformations:shiftcolumn|Shift column up/down]] - Shifts column values up or down. | * [[transformations:shiftcolumn|Shift column up/down]] - Shifts column values up or down. |
* [[transformations:splitdelimitedtext|Split delimited text into columns]] - split delimited values of a column into new columns. | * [[transformations:splitdelimitedtext|Split delimited text into columns]] - Split delimited values of a column into new columns. |
* [[transformations:subfield|Split delimited text into rows]] - split delimited values of a column into rows. | * [[transformations:subfield|Split delimited text into rows]] - Split delimited values of a column into rows. |
* [[transformations:splitfixedwidthtext|Split fixed width text]] - split a column with fixed width text values into new columns. | * [[transformations:splitfixedwidthtext|Split fixed width text]] - Split a column with fixed width text values into new columns. |
* [[transformations:metadata|Table metadata]] - obtain column names, total row count and other table metadata. | * [[transformations:metadata|Table metadata]] - Obtain column names, total row count and other table metadata. |
* [[transformations:massreplace|Table-wide replace]] - remove or replace values across selected columns. | * [[transformations:massreplace|Table-wide replace]] - Remove or replace values across selected columns. |
* [[transformations:unpivot|Unpivot]] - convert a matrix table into a straight table. | * [[transformations:unpivot|Unpivot]] - Convert a matrix table into a straight table. |
| |
==== Transform / Filters ==== | ==== Transform / Filters ==== |
* [[transformations:exporttext|Export into delimited text file]] - export data into CSV or another delimited text format. | * [[transformations:exporttext|Export into delimited text file]] - export data into CSV or another delimited text format. |
* [[transformations:exportexcel|Export into Excel spreadsheet]] - export data into an Excel spreadsheet. | * [[transformations:exportexcel|Export into Excel spreadsheet]] - export data into an Excel spreadsheet. |
* [[transformations:exportqlikview|Export into QlikView file]] - export data into a QlikView QVD file. | * [[transformations:exportdataset|Export dataset]] - export dataset into a file in the native EasyMorph data format (.dset). |
| * [[transformations:exportqlikview|Export into Qlik file]] - export data into a Qlik QVD file. |
* [[transformations:export1010data|Export into 1010data]] - export into 1010data (experimental, not supported). | * [[transformations:export1010data|Export into 1010data]] - export into 1010data (experimental, not supported). |
* [[transformations:exporttableau|Export into Tableau]] - export data into a Tableau Data Extract. | * [[transformations:exporttableau|Export into Tableau]] - export data into a Tableau Data Extract or publish to Tableau Server. |
| * [[transformations:exportxml|Export into XML file]] - export data into a XML file. |
| |
==== Workflow / Internal ==== | ==== Workflow / Internal ==== |
| |
==== Workflow / External ==== | ==== Workflow / External ==== |
| * [[transformations:amazoncommand|Amazon command]] - perform an AWS S3 command (e.g. upload/download a file). |
* [[transformations:sqlcommand|Database command]] - create/delete/truncate DB table or send a custom SQL command to a database (e.g. to bulk load a file). | * [[transformations:sqlcommand|Database command]] - create/delete/truncate DB table or send a custom SQL command to a database (e.g. to bulk load a file). |
* [[transformations:deletedbrows|Delete database rows]] - delete rows in a database table that satisfy query condition. | * [[transformations:deletedbrows|Delete database rows]] - delete rows in a database table that satisfy query condition. |
* [[transformations:downloadfile|Download file]] - download a file from the internet. | * [[transformations:downloadfile|Download file]] - download a file from the internet. |
* [[transformations:morphservercommand|EasyMorph Server command]] - Trigger a task, or upload/download/delete a file on a remote EasyMorph Server. | * [[transformations:morphservercommand|EasyMorph Server command]] - Trigger a task, or upload/download/delete a file on a remote EasyMorph Server. |
| * [[transformations:fetchemail|Fetch email]] - fetch email messages and their attachments from a mail server (Exchange or IMAP). |
* [[transformations:filecommand|File command]] - performs basic file operations such as copy/move/rename/delete/unzip. | * [[transformations:filecommand|File command]] - performs basic file operations such as copy/move/rename/delete/unzip. |
| * [[transformations:filetransfer|File transfer]] - transfer files over SFTP or SCP to or from a remote computer. |
* [[transformations:iterateprogram|Iterate external program]] - execute external application once for each row in table. | * [[transformations:iterateprogram|Iterate external program]] - execute external application once for each row in table. |
* [[transformations:powershell|PowerShell]] - executes one or more PowerShell statements. | * [[transformations:powershell|PowerShell]] - executes one or more PowerShell statements. |
* [[transformations:qliksensecommand|Qlik Sense command]] - execute a Qlik Sense command remotely.. | * [[transformations:qliksensecommand|Qlik Sense command]] - execute a Qlik Sense command remotely. |
* [[transformations:runprogram|Run external program]] - execute external application once. | * [[transformations:runprogram|Run external program]] - execute external application once. |
* [[transformations:sendemail|Send email]] - send an email with attachment to one or more recipients. | * [[transformations:sendemail|Send email]] - send an email with attachment to one or more recipients. |
| * [[transformations:sshcommand|SSH command]] - run one or several commands on a remote computer using the SSH protocol. |
* [[transformations:tableaucommand|Tableau Server command]] - trigger extract refresh on a Tableau Server. | * [[transformations:tableaucommand|Tableau Server command]] - trigger extract refresh on a Tableau Server. |
* [[transformations:xslt|XSLT]] - transform given XML file using XSLT stylesheets. | * [[transformations:xslt|XSLT]] - transform given XML file using XSLT stylesheets. |