Both sides previous revisionPrevious revisionNext revision | Previous revisionNext revisionBoth sides next revision |
transformations:start [2021/06/20 19:48] – [Workflow / External] craigt | transformations:start [2021/07/08 17:37] – [Workflow / Internal] dmitry |
---|
==== Import / App & Cloud ==== | ==== Import / App & Cloud ==== |
* [[transformations:importairtable|Import from Airtable]] - import a table from Airtable. | * [[transformations:importairtable|Import from Airtable]] - import a table from Airtable. |
* [[transformations:importpipedrive|Import from Pipedrive]] - import deals, organizations, persons from the Pipedrive CRM. | |
* [[transformations:importgoogleanalytics|Import from Google Analytics]] - import metrics from Google Analytics. | * [[transformations:importgoogleanalytics|Import from Google Analytics]] - import metrics from Google Analytics. |
| * [[transformations:importpipedrive|Import from Pipedrive]] - import deals, organizations, persons from the Pipedrive CRM. |
| * [[transformations:importwebapi|Import from Web API]] - import data from a Web API. |
* [[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. |
| |
==== Transform / Math ==== | ==== Transform / Math ==== |
| * [[transformations:distributetotal|Distribute total]] - Break down a total/subtotal proportionally to a group of numbers (weights). |
* [[transformations:linearregression|Linear regression]] - Build a linear regression. Interpolate/extrapolate values if needed. | * [[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. | |
* [[transformations:runningtotal|Running total]] - Calculate rank, cumulative count, sum or % from total sum. | * [[transformations:runningtotal|Running total]] - Calculate rank, cumulative count, sum or % from total sum. |
| * [[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. |
| |
* [[transformations:haltontypemismatch|Halt on data type mismatch]] - abort project execution if a value in specified column(s) has a wrong type. | * [[transformations:haltontypemismatch|Halt on data type mismatch]] - abort project execution if a value in specified column(s) has a wrong type. |
* [[transformations:iterate|Iterate]] - run another module/project once for each row in table. | * [[transformations:iterate|Iterate]] - run another module/project once for each row in table. |
* [[transformations:iteratecolumns|Iterate column]] - run another module/project once for each column in table and automatically append all returned columns into one table. | * [[transformations:iteratecolumn|Iterate column]] - run another module/project once for each column in table and automatically append all returned columns into one table. |
* [[transformations:iteratetable|Iterate table]] - run another module/project once for each row in table and pass another table to it. | * [[transformations:iteratetable|Iterate table]] - run another module/project once for each row in table and pass another table to it. |
* [[transformations:repeat|Repeat]] - run another module/project until/while its output is empty | * [[transformations:repeat|Repeat]] - run another module/project until/while its output is empty |