Both sides previous revisionPrevious revisionNext revision | Previous revisionNext revisionBoth sides next revision |
transformations:start [2021/07/08 17:08] – [Transform / Math] dmitry | transformations:start [2021/10/31 21:25] – [Import / App & Cloud] craigt |
---|
* [[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:importpipedrive|Import from Pipedrive]] - import deals, organizations, persons from the Pipedrive CRM. |
| * [[transformations:importsalesforce|Import from Salesforce]] - import rows from a Salesforce object. |
* [[transformations:importwebapi|Import from Web API]] - import data from a Web API. | * [[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. |
| |
| |
| |
==== Create / Generate ==== | ==== Create / Generate ==== |
* [[transformations:calendar|Calendar]] - create a sequence of dates in specified date range | * [[transformations:calendar|Calendar]] - create a sequence of dates in specified date range |
* [[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: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 file]] - export data into an Excel spreadsheet. |
* [[transformations:exportplaintext|Export as plain text]] - export a column as a plain text file without formatting or delimiting. | * [[transformations:exportplaintext|Export as plain text]] - export a column as a plain text file without formatting or delimiting. |
* [[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. |
* [[transformations:exportgooglesheets|Export into Google Sheets]] - export data into a Google Sheets spreadsheet. | * [[transformations:exportgooglesheets|Export into Google Sheets]] - export data into a Google Sheets spreadsheet. |
* [[transformations:exportpowerbi|Export to Power BI]] - export to Power BI push-dataset. | * [[transformations:exportpowerbi|Export to Power BI]] - export to Power BI push-dataset. |
| * [[transformations:exportsalesforce|Export to Salesforce]] - insert records into a Salesforce object. |
| * [[transformations:exportsharepointlist|Export to SharePoint list]] - append rows to a SharePoint list. |
* [[transformations:exporttableau|Export to Tableau]] - export data into a Tableau TDE/Hyper file or publish to Tableau Server/Online. | * [[transformations:exporttableau|Export to Tableau]] - export data into a Tableau TDE/Hyper file or publish to Tableau Server/Online. |
| |
* [[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. |
| * [[transformations:sharedmemory|Shared memory]] - perform operations on shared memory, a key-value data respository. |
* [[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:exclusiveaccess|Start/finish exclusive access]] - enforce mutually exclusive access to a resource for simultaneously executed projects (tasks). |
* [[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:deletedbrowsbykeys|Delete matching database rows]] - delete rows in a database table where key values match (or don't match) key values in an EasyMorph table. | * [[transformations:deletedbrowsbykeys|Delete matching database rows]] - delete rows in a database table where key values match/don't match key values in an EasyMorph table. |
* [[transformations:downloadfile|Download file]] - download a file from the internet. | * [[transformations:downloadfile|Download file]] - download a file from the internet. |
* [[transformations:fetchemail|Fetch email]] - fetch email messages and their attachments from a mail server (Exchange or IMAP). | * [[transformations:fetchemail|Fetch email]] - fetch email messages and their attachments from a mail server (Exchange or IMAP). |
* [[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. |
* [[transformations:sharepointcommand|SharePoint command]] - transfer file(s) to/from SharePoint. | * [[transformations:sharepointcommand|SharePoint command]] - perform file operations within SharePoint. |
* [[transformations:tableaucommand|Tableau Server command]] - trigger extract refresh or run a flow on Tableau Server / Online. | * [[transformations:tableaucommand|Tableau Server command]] - trigger extract refresh or run a flow on Tableau Server / Online. |
* [[transformations:airtablecommand|Update/delete rows in Airtable]] - Update or delete rows in Airtable. | * [[transformations:airtablecommand|Update/delete rows in Airtable]] - update or delete rows in Airtable. |
| * [[transformations:sharepointlistcommand|Update/delete rows in SharePoint list]] - update or delete rows in a SharePoint list. |
| |
:?: If you need an action that is not currently available in EasyMorph please feel free to make a feature request on the [[https://community.easymorph.com|Community forum]]. | :?: If you need an action that is not currently available in EasyMorph please feel free to make a feature request on the [[https://community.easymorph.com|Community forum]]. |