User Tools

Site Tools


transformations:start

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revision Previous revision
transformations:start [2019/04/29 23:15]
dmitry [Export]
transformations:start [2019/04/29 23:20] (current)
dmitry
Line 4: Line 4:
  
 ==== 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 ====
Line 90: Line 90:
   * [[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.
Line 107: Line 108:
  
 ==== 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.
Line 116: Line 117:
   * [[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.
transformations/start.txt · Last modified: 2019/04/29 23:20 by dmitry