Both sides previous revisionPrevious revisionNext revision | Previous revisionNext revisionBoth sides next revision |
transformations:start [2021/11/01 15:55] – [Workflow / External] Add Excel Command craigt | transformations:start [2022/08/26 04:26] – [Transform / Math] dmitry |
---|
* [[transformations:importgooglesheets|Import Google Sheets]] - import data from a Google Sheets spreadsheet. | * [[transformations:importgooglesheets|Import Google Sheets]] - import data from a Google Sheets spreadsheet. |
* [[transformations:importsharepointlist|Import SharePoint list]] - import a SharePoint list. | * [[transformations:importsharepointlist|Import SharePoint list]] - import a SharePoint list. |
| * [[transformations:incomingwebhooks|Incoming webhooks]] - import incoming webhook messages from EasyMorph Gateway |
| |
| |
* [[transformations:statisticalaggregation|Statistical aggregation]] - Calculate median, percentile, standard error, standard deviation, or variance. | * [[transformations:statisticalaggregation|Statistical aggregation]] - Calculate median, percentile, standard error, standard deviation, or variance. |
* [[transformations:subtotal|Total/subtotals]] - add column total or group subtotals as a new column. | * [[transformations:subtotal|Total/subtotals]] - add column total or group subtotals as a new column. |
| |
| |
| ==== Transform / Web ==== |
| |
| * [[transformations:extractjsonproperties|Extract JSON properties]] - Extract values of one or more JSON properties specified by JSON path. |
| * [[transformations:modifyjson|Modify JSON]] - Delete, replace, or rename a JSON property or format JSON. |
| * [[transformations:splitjsonarray|Split JSON array]] - Split a JSON array into rows. |
| |
==== Export / File ==== | ==== Export / File ==== |
| |
==== Workflow / Internal ==== | ==== Workflow / Internal ==== |
| * [[transformations:breakpoint|Breakpoint]] - stop project execution. |
* [[transformations:call|Call another module/project]] - pass table data to another project and run it once. | * [[transformations:call|Call another module/project]] - pass table data to another project and run it once. |
* [[transformations:either|Either table]] - between current table and another table choose one that is not empty. | * [[transformations:either|Either table]] - between current table and another table choose one that is not empty. |
* [[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:googledrivecommand|Google Drive command]] - perform an operation with Google Drive, e.g. download a file. | * [[transformations:googledrivecommand|Google Drive command]] - perform an operation with Google Drive, e.g. download a file. |
| * [[transformations:onedrivecommand|OneDrive command]] - perform file operations within OneDrive. |
* [[transformations:powerbicommand|Power BI command]] - trigger a Power BI action, such as refreshing a dataset or triggering a workflow. | * [[transformations:powerbicommand|Power BI command]] - trigger a Power BI action, such as refreshing a dataset or triggering a workflow. |
* [[transformations:qliksensecommand|Qlik Sense command]] - execute a Qlik Sense command remotely. | * [[transformations:qliksensecommand|Qlik Sense command]] - execute a Qlik Sense command remotely. |