| Both sides previous revisionPrevious revision | Next revisionBoth sides next revision |
| transformations:start [2023/09/28 18:01] – [Transform / Web] 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 ==== |
