Both sides previous revisionPrevious revisionNext revision | Previous revisionNext revisionBoth sides next revision |
transformations:start [2023/09/28 18:01] – [Transform / Web] craigt | transformations:start [2024/02/03 17:51] – craigt |
---|
* [[transformations:importexcel|Import Excel spreadsheet]] - import data from Excel spreadsheets (.xls,.xlsx). | * [[transformations:importexcel|Import Excel spreadsheet]] - import data from Excel spreadsheets (.xls,.xlsx). |
* [[transformations:importfixedwidthtext|Import fixed width text]] - import tabular data with fixed width columns from text file. | * [[transformations:importfixedwidthtext|Import fixed width text]] - import tabular data with fixed width columns from text file. |
| * [[transformations:importapacheparquet|Import from Apache Parquet]] - import columns or metadata from an Apache Parquet file. |
* [[transformations:importjson|Import JSON from file]] - import JSON from a text file. | * [[transformations:importjson|Import JSON from file]] - import JSON from a text file. |
* [[transformations:importplaintext|Import plain text]] - import a text file as is without parsing. | * [[transformations:importplaintext|Import plain text]] - import a text file as is without parsing. |
| |
==== Transform / Advanced ==== | ==== Transform / Advanced ==== |
* [[transformations:compare|Compare tables]] - Compares two tables and produces a list of differences based on column metadata. | * [[transformations:compare|Compare tables]] - compares two tables and produces a list of differences based on column metadata. |
* [[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:distributetotal|Distribute total]] - Break down a total/subtotal proportionally to a group of numbers (weights). | * [[transformations:distributetotal|Distribute total]] - break down a total/subtotal proportionally to a group of numbers (weights). |
* [[transformations:enumerategroups|Enumerate groups]] - Enumerate all combinations of values in given columns. | * [[transformations:enumerategroups|Enumerate groups]] - enumerate all combinations of values in given columns. |
* [[transformations:fillgaps|Fill down]] - Fill down empty cells. | * [[transformations:fillgaps|Fill down]] - fill down empty cells. |
* [[transformations:fillright|Fill right]] - Fill empty cells to the right. | * [[transformations:fillright|Fill right]] - fill empty cells to the right. |
* [[transformations:generateuids|Generate unique identifiers]] - Creates a randomly generated global unique identifier for each row. | * [[transformations:generateuids|Generate unique identifiers]] - creates a randomly generated global unique identifier for each row. |
* [[transformations:group|Group]] - Assign a group name (or flag) to selected column values. | * [[transformations:group|Group]] - assign a group name (or flag) to selected column values. |
* [[transformations:hierarchypath|Hierarchy path]] - Generate a parent-child hierarchy path. | * [[transformations:hierarchypath|Hierarchy path]] - generate a parent-child hierarchy path. |
* [[transformations:intervalmerge|Interval merge]] - Merge columns from another table where key values fall into an interval defined by two columns. | * [[transformations:intervalmerge|Interval merge]] - merge columns from another table where key values fall into an interval defined by two columns. |
* [[transformations:labelcolumns|Label columns]] - Name columns using values from top rows. | * [[transformations:labelcolumns|Label columns]] - name columns using values from top rows. |
* [[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: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:naturalmerge|Natural merge]] - Merges two tables based on columns with the same names. | * [[transformations:naturalmerge|Natural merge]] - merges two tables based on columns with the same names. |
* [[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:removeemptycolumns|Remove empty columns]] - Remove columns where all values are the same or empty. | * [[transformations:removeemptycolumns|Remove empty columns]] - remove columns where all values are the same or empty. |
* [[transformations:removeemptyrows|Remove empty rows]] - Remove rows where all values are empty or whitespace. | * [[transformations:removeemptyrows|Remove empty rows]] - remove rows where all values are empty or whitespace. |
* [[transformations:lookuprename|Rename columns by lookup]] - Rename multiple columns using a lookup table. | * [[transformations:lookuprename|Rename columns by lookup]] - rename multiple columns using a lookup table. |
* [[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:rollup|Roll up]] - Adds amounts up through a hierarchy. | * [[transformations:rollup|Roll up]] - adds amounts up through a hierarchy. |
* [[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: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. |
* [[transformations:shiftcolumn|Shift column up/down]] - Shifts column values up or down. | * [[transformations:shiftcolumn|Shift column up/down]] - shifts column values up or down. |
* [[transformations:splitdelimitedtext|Split delimited text into columns]] - Split delimited values of a column into new columns. | * [[transformations:splitdelimitedtext|Split delimited text into columns]] - split delimited values of a column into new columns. |
* [[transformations:subfield|Split delimited text into rows]] - Split delimited values of a column into rows. | * [[transformations:subfield|Split delimited text into rows]] - split delimited values of a column into rows. |
* [[transformations:splitfixedwidthtext|Split fixed width text]] - Split a column with fixed width text values into new columns. | * [[transformations:splitfixedwidthtext|Split fixed width text]] - split a column with fixed width text values into new columns. |
* [[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:metadata|Table metadata]] - Obtain column names, total row count and other table metadata. | * [[transformations:metadata|Table metadata]] - obtain column names, total row count and other table metadata. |
* [[transformations:massreplace|Table-wide replace]] - Remove or replace values across selected columns. | * [[transformations:massreplace|Table-wide replace]] - remove or replace values across selected columns. |
* [[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:unpivot|Unpivot]] - Convert a matrix table into a straight table. | * [[transformations:unpivot|Unpivot]] - convert a matrix table into a straight table. |
| |
==== Transform / Filters ==== | ==== Transform / Filters ==== |
* [[transformations:filterminmax|Keep min/max]] - keep/remove rows with the top N biggest/smallest values. | * [[transformations:filterminmax|Keep min/max]] - keep/remove rows with the top N biggest/smallest values. |
* [[transformations:keepremovematching|Keep/remove matching]] - keep or remove rows with values that exist in another table. | * [[transformations:keepremovematching|Keep/remove matching]] - keep or remove rows with values that exist in another table. |
* [[transformations:keeptop|Trim table]] - keep/remove top/bottom N rows. | * [[transformations:trimtable|Trim table]] - keep/remove top/bottom N rows. |
* [[transformations:trimbycondition|Trim table by condition]] - keep/remove rows above/below first row matching condition. | * [[transformations:trimbycondition|Trim table by condition]] - keep/remove rows above/below first row matching condition. |
| |
* [[transformations:catalogcommand|Catalog command]] - list/create/update/delete Catalog directories, items, and item fields. | * [[transformations:catalogcommand|Catalog command]] - list/create/update/delete Catalog directories, items, and item fields. |
* [[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 conditions. |
* [[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: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:emailcommand|Email command]] - performs various operations with email messages. |
* [[transformations:excelcommand|Excel command]] - perform file/sheet operations and run VBA macros in Excel files. | * [[transformations:excelcommand|Excel command]] - perform file/sheet operations and run VBA macros in Excel files. |
* [[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: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 documentation]] - generate HTML documentation for an EasyMorph project. | * [[transformations:generatedocumentation|Generate documentation]] - generate HTML documentation for an EasyMorph project. |
* [[transformations:iterateprogram|Iterate program]] - execute external application once for each row in table. | * [[transformations:iterateprogram|Iterate program]] - execute external application once for each row in a 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 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 an 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: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. |
* [[transformations:xslt|XSLT transformation]] - transform given XML file using XSLT stylesheets. | * [[transformations:xslt|XSLT transformation]] - transform a given XML file using XSLT stylesheets. |
| |
| |
| |
==== Workflow / Apps and cloud ==== | ==== Workflow / Apps and cloud ==== |
* [[transformations:amazoncommand|Amazon command]] - perform an operation with AWS S3 , e.g. upload/download a file. | * [[transformations:amazoncommand|Amazon command]] - perform an operation with AWS S3 , e.g. upload/download a file. |
| * [[transformations:chatgpt|Ask ChatGPT]] - sends free-form prompts to ChatGPT. |
* [[transformations:azureblobstoragecommand|Azure Blob Storage command]] - performs various file and folder operations with Azure Blob Storage. | * [[transformations:azureblobstoragecommand|Azure Blob Storage command]] - performs various file and folder operations with Azure Blob Storage. |
| * [[transformations:dropboxcommand|Dropbox command]] - performs various file and folder operations with Dropbox. |
* [[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: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:salesforcecommand|Update/delete records in Salesforce]] - update/delete records in a Salesforce object. |
* [[transformations:sharepointlistcommand|Update/delete rows in SharePoint list]] - update or delete rows in a SharePoint list. | * [[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]]. |