| Both sides previous revisionPrevious revisionNext revision | Previous revisionNext revisionBoth sides next revision |
| transformations:start [2021/11/12 22:22] – [Workflow / Apps and cloud] Add OneDrive Command craigt | transformations:start [2022/08/26 04:28] – 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 |
| |
| |
| |
| ==== 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: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:makedatetimecolumns|Make date/time columns]] - Create column(s) with date/time attributes derived from a date column. | * [[transformations:makedatetimecolumns|Make date/time columns]] - Create column(s) with date/time attributes derived from a date column. |
| * [[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:parsexml|Parse XML]] - Parse XML 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: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:constructjson|Construct JSON]] - Construct a JSON object. |
| | * [[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:parsejson|Parse JSON]] - Parse a JSON object into a tabular dataset. |
| | * [[transformations:parsexml|Parse XML]] - Parse XML into a tabular dataset. |
| | * [[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. |
