User Tools

Site Tools


transformations:start

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revisionPrevious revision
Next revisionBoth sides next revision
transformations:start [2019/10/08 12:42] – [Workflow / External] dmitrytransformations:start [2019/10/08 12:46] dmitry
Line 38: Line 38:
   * [[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.
Line 51: Line 52:
 ==== 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.
Line 83: Line 85:
   * [[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.
transformations/start.txt · Last modified: 2024/02/03 18:00 by craigt

Donate Powered by PHP Valid HTML5 Valid CSS Driven by DokuWiki