| Both sides previous revisionPrevious revisionNext revision | Previous revisionNext revisionBoth sides next revision |
| transformations:start [2023/09/28 18:01] – [Transform / Web] craigt | transformations:start [2023/10/15 21:03] – [Workflow / External] craigt |
|---|
| |
| ==== 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: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: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. |
