Both sides previous revisionPrevious revisionNext revision | Previous revisionNext revisionBoth sides next revision |
transformations:start [2023/09/28 18:00] – [Workflow / Apps and cloud] Add Azure Blog Storage craigt | transformations:start [2023/09/28 18:03] – [Transform / Advanced] 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 ==== |
| |
==== Transform / Web ==== | ==== Transform / Web ==== |
* [[transformations:constructhttpresponse|Construct HTTP response]] - Construct fields required for an HTTP response of the API Server. | * [[transformations:constructhttpresponse|Construct HTTP response]] - construct fields required for an HTTP response of the API Server. |
* [[transformations:constructjson|Construct JSON]] - Construct a JSON object. | * [[transformations:constructjson|Construct JSON]] - construct a JSON object. |
* [[transformations:extractjson|Extract JSON properties]] - Extract values of one or more JSON properties specified by JSON path. | * [[transformations:extractjson|Extract JSON properties]] - extract values of one or more JSON properties specified by JSON path. |
* [[transformations:modifyjson|Modify JSON]] - Delete, replace, or rename a JSON property or format JSON. | * [[transformations:modifyjson|Modify JSON]] - delete, replace, or rename a JSON property or format JSON. |
* [[transformations:parsejson|Parse JSON]] - Parse a JSON object into a tabular dataset. | * [[transformations:parsejson|Parse JSON]] - parse a JSON object into a tabular dataset. |
* [[transformations:parseformsubmission|Parse web form submission]] - Parse web form submissions in the "x-www-form-urlencoded" format. | * [[transformations:parseformsubmission|Parse web form submission]] - parse web form submissions in the "x-www-form-urlencoded" format. |
* [[transformations:parsexml|Parse XML]] - Parse XML into a tabular dataset. | * [[transformations:parsexml|Parse XML]] - parse XML into a tabular dataset. |
* [[transformations:splitjsonarray|Split JSON array]] - Split a JSON array into rows. | * [[transformations:splitjsonarray|Split JSON array]] - split a JSON array into rows. |
==== Export / File ==== | ==== Export / File ==== |
* [[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). |