Both sides previous revisionPrevious revisionNext revision | Previous revisionNext revisionBoth sides next revision |
transformations:start [2021/06/14 23:38] – [Export / Database] craigt | transformations:start [2021/07/08 17:08] – [Transform / Math] 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. |
* [[transformations:repeatrows|Repeat rows]] - repeat each row as many times as specified in given column. | * [[transformations:repeatrows|Repeat rows]] - repeat each row as many times as specified in given column. |
* [[transformations:replacewithlookup|Replace with lookup]] - replace all substrings in one or many columns using a lookup table. | * [[transformations:replacewithlookup|Replace with lookup]] - replace all substrings in one or many columns using a lookup table. |
* [[transformations:runningtotal|Running total]] - Calculate rank, cumulative count, sum or % from total sum. | |
* [[transformations:sanitize|Sanitize text]] - Remove hidden system characters, extra spaces, and line breaks. | * [[transformations:sanitize|Sanitize text]] - Remove hidden system characters, extra spaces, and line breaks. |
* [[transformations:selectbylookup|Select columns by lookup]] - Select columns using a lookup table. | * [[transformations:selectbylookup|Select columns by lookup]] - Select columns using a lookup table. |
| |
==== 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: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: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: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 |
* [[transformations:skiponcondition|Skip actions on condition]] - skip the rest of action in table if the specified condition is fulfilled. | * [[transformations:skiponcondition|Skip actions on condition]] - skip the rest of action in table if the specified condition is fulfilled. |
| * [[transformations:exclusiveaccess|Start/finish exclusive access]] - enforce mutually exclusive access to a resource for simultaneously executed projects (tasks). |
* [[transformations:status|Status]] - display custom project execution status message. | * [[transformations:status|Status]] - display custom project execution status message. |
* [[transformations:synchronize|Synchronize]] - wait until another table is calculated. | * [[transformations:synchronize|Synchronize]] - wait until another table is calculated. |
* [[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:generatedocumentation|Generate project documentation]] - generate HTML documentation for an EasyMorph project. | * [[transformations:generatedocumentation|Generate project documentation]] - generate HTML documentation for an EasyMorph project. |
* [[transformations:iterateprogram|Iterate external program]] - execute external application once for each row in table. | * [[transformations:iterateprogram|Iterate 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: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:runprogram|Run external program]] - execute external application once. | * [[transformations:runprogram|Run 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: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:exclusiveaccess|Start/finish exclusive access]] - enforce mutually exclusive access to a resource for simultaneously executed projects (tasks). | |
* [[transformations:updatedb|Update database table]] - update a database table with values from EasyMorph. | * [[transformations:updatedb|Update database table]] - update a database table with values from EasyMorph. |
* [[transformations:webrequest|Web Request]] - send an HTTP request to a web API and receive a response. | * [[transformations:webrequest|Web Request]] - send an HTTP request to a web API and receive a response. |