Both sides previous revisionPrevious revision | Next revisionBoth sides next revision |
transformations:start [2019/04/29 19:15] – [Export] dmitry | transformations:start [2019/04/29 19:20] – dmitry |
---|
| |
==== Import ==== | ==== Import ==== |
* [[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: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:importgooglesheets|Import from Google Sheets]] - import data from a Google Sheets 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). |
* [[transformations:importspss|Import SPSS file]] - import data from a SPSS/PSPP file (.sav) | * [[transformations:importspss|Import SPSS file]] - import data from a SPSS/PSPP file (.sav). |
* [[transformations:importxml|Import XML file]] - import data from an XML file | * [[transformations:importxml|Import XML file]] - import data from an XML file. |
* [[transformations:selectdbrowsbykeys|Select matching database rows]] - import rows from a database table where key values match (or don't match) key values in EasyMorph table. | * [[transformations:selectdbrowsbykeys|Select matching database rows]] - import rows from a database table where key values match (or don't match) key values in EasyMorph table. |
* [[transformations:filesplitter|Split delimited text file]] - split large file into smaller chunks without loading it into EasyMorph | * [[transformations:filesplitter|Split delimited text file]] - split large file into smaller chunks without loading it into EasyMorph. |
* [[transformations:spreadsheetmetadata|Spreadsheet metadata]] - create a list with names of all sheets in a spreadsheet | * [[transformations:spreadsheetmetadata|Spreadsheet metadata]] - create a list with names of all sheets in a spreadsheet. |
| |
==== Create ==== | ==== Create ==== |
* [[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:exportgooglesheets|Export into Google Sheets]] - export data into a Google Sheets spreadsheet. |
* [[transformations:exportdataset|Export dataset]] - export dataset into a file in the native EasyMorph data format (.dset). | * [[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:exportqlikview|Export into Qlik file]] - export data into a Qlik QVD file. |
| |
==== Workflow / External ==== | ==== Workflow / External ==== |
* [[transformations:amazoncommand|Amazon command]] - perform an AWS S3 command (e.g. upload/download a file). | * [[transformations:amazoncommand|Amazon command]] - perform an operation with AWS S3 , 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: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:filetransfer|File transfer]] - transfer files over SFTP or SCP to or from a remote computer. |
| * [[transformations:googledrivecommand|Google Drive command]] - perform an operation with Google Drive, e.g. download a file. |
* [[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. |