Both sides previous revisionPrevious revision | Next revisionBoth sides next revision |
transformations:start [2019/10/08 12:42] – [Workflow / External] dmitry | transformations:start [2019/10/08 12:46] – dmitry |
---|
* [[transformations:lookup|Lookup]] - replace values in a column using a lookup table. | * [[transformations:lookup|Lookup]] - replace values in a column using a lookup table. |
* [[transformations:merge|Merge another table]] - merge (join) one or more columns from another table where certain columns in both tables match. | * [[transformations:merge|Merge another table]] - merge (join) one or more columns from another table where certain columns in both tables match. |
| * [[transformations:repeatrows|Repeat rows]] - repeat each row as many times as specified in given column. |
* [[transformations:replacecolumn|Modify column]] - replace existing column with a calculated [[syntax:start|expression]]. | * [[transformations:replacecolumn|Modify column]] - replace existing column with a calculated [[syntax:start|expression]]. |
* [[transformations:peek|Peek]] - create a new column using a single value from another table. | * [[transformations:peek|Peek]] - create a new column using a single value from another table. |
==== Transform / Advanced ==== | ==== Transform / Advanced ==== |
* [[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: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: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:keepdifferent|Keep mismatching]] - keep rows with values that don't exist in another table. | * [[transformations:keepdifferent|Keep mismatching]] - keep rows with values that don't exist in another table. |
| * [[transformations:keepremovematching|Keep/remove matching]] - keep or remove rows with values that exist in another table. |
* [[transformations:keepexisting|Keep matching]] - keep rows with values that exist in another table. | * [[transformations:keepexisting|Keep matching]] - keep rows with values that exist in another table. |
* [[transformations:keeptop|Trim table]] - keep/remove top/bottom N rows. | * [[transformations:keeptop|Trim table]] - keep/remove top/bottom N rows. |