| Both sides previous revisionPrevious revisionNext revision | Previous revisionNext revisionBoth sides next revision |
| transformations:start [2019/04/29 19:15] – [Export] dmitry | transformations:start [2019/12/07 12:31] – added 7 more actions 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:importsharepointlist|Import SharePoint list]] - import a SharePoint list. |
| * [[transformations:importxml|Import XML file]] - import data from an XML file | * [[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: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:enumerate|Enumerate rows]] - add column with row numbers. | * [[transformations:enumerate|Enumerate rows]] - add column with row numbers. |
| * [[transformations:lookup|Lookup]] - replace values in a column using a lookup table. | * [[transformations:lookup|Lookup]] - replace values in a column using a lookup table. |
| | * [[transformations:makedatetimecolumns|Make date/time columns]] - Create column(s) with date/time attributes derived from a date column. |
| * [[transformations:merge|Merge another table]] - merge (join) one or more columns from another table where certain columns in both tables match. | * [[transformations:merge|Merge another table]] - merge (join) one or more columns from another table where certain columns in both tables match. |
| | * [[transformations:repeatrows|Repeat rows]] - repeat each row as many times as specified in given column. |
| * [[transformations:replacecolumn|Modify column]] - replace existing column with a calculated [[syntax:start|expression]]. | * [[transformations:replacecolumn|Modify column]] - replace existing column with a calculated [[syntax:start|expression]]. |
| * [[transformations:peek|Peek]] - create a new column using a single value from another table. | * [[transformations:peek|Peek]] - create a new column using a single value from another table. |
| |
| ==== Transform / Advanced ==== | ==== Transform / Advanced ==== |
| | * [[transformations:constructjson|Construct JSON]] - Construct a JSON object. |
| | * [[transformations:createbuckets|Create buckets]] - Create ranges of fixed width and assign each row to one of the ranges. |
| * [[transformations:crossmerge|Cross merge]] - Create a table with all possible combinations (i.e. Cartesian product) of rows in two tables. | * [[transformations:crossmerge|Cross merge]] - Create a table with all possible combinations (i.e. Cartesian product) of rows in two tables. |
| | * [[transformations:enumerategroups|Enumerate Groups]] - Enumerate all combinations of values in given columns. |
| * [[transformations:fillgaps|Fill down]] - Fill down empty cells. | * [[transformations:fillgaps|Fill down]] - Fill down empty cells. |
| * [[transformations:fillright|Fill right]] - Fill empty cells to the right. | * [[transformations:fillright|Fill right]] - Fill empty cells to the right. |
| * [[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:iteratecolumns|Iterate columns]] - Iterate module/project by passing it columns one by one. Append the results back into one table. |
| * [[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:parsejson|Parse JSON]] - Parse a JSON object into a tabular dataset. |
| * [[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:filterminmax|Keep min/max]] - keep/remove rows with the top N biggest/smallest values. | * [[transformations:filterminmax|Keep min/max]] - keep/remove rows with the top N biggest/smallest values. |
| * [[transformations:keepdifferent|Keep mismatching]] - keep rows with values that don't exist in another table. | * [[transformations:keepdifferent|Keep mismatching]] - keep rows with values that don't exist in another table. |
| | * [[transformations:keepremovematching|Keep/remove matching]] - keep or remove rows with values that exist in another table. |
| * [[transformations:keepexisting|Keep matching]] - keep rows with values that exist in another table. | * [[transformations:keepexisting|Keep matching]] - keep rows with values that exist in another table. |
| * [[transformations:keeptop|Trim table]] - keep/remove top/bottom N rows. | * [[transformations:keeptop|Trim table]] - keep/remove top/bottom N rows. |
| * [[transformations:trimbycondition|Trim table by condition]] - keep/remove rows above/below first row matching condition. | * [[transformations:trimbycondition|Trim table by condition]] - keep/remove rows above/below first row matching condition. |
| | |
| | ==== Transform / Math ==== |
| | * [[transformations:linearregression|Linear regression]] - Build a linear regression. Interpolate/extrapolate values if needed. |
| | * [[transformations:statisticalaggregation|Statistical aggregation]] - Calculate median, percentile, standard error, standard deviation, or variance. |
| |
| ==== Export ==== | ==== Export ==== |
| * [[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:iteratewebrequest|Iterate Web Request]] - send multiple uniform HTTP requests to a web API and append responses into one 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:sharepointcommand|SharePoint Command]] - transfer file(s) to/from SharePoint. |
| * [[transformations:sshcommand|SSH command]] - run one or several commands on a remote computer using the SSH protocol. | * [[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:webrequest|Web Request]] - send an HTTP request to a web API and receive a response. |
| * [[transformations:xslt|XSLT]] - transform given XML file using XSLT stylesheets. | * [[transformations:xslt|XSLT]] - transform given XML file using XSLT stylesheets. |
