transformations:peek
Differences
This shows you the differences between two versions of the page.
Next revisionBoth sides next revision | |||
transformations:peek [2015/10/01 22:21] – created dmitry | transformations:peek [2015/10/01 22:27] – dmitry | ||
---|---|---|---|
Line 2: | Line 2: | ||
This transformation takes a value from another table and creates a new column populated with this values. A typical use case for the transformation would be bringing in some total value from another table for further calculation such as % from total. | This transformation takes a value from another table and creates a new column populated with this values. A typical use case for the transformation would be bringing in some total value from another table for further calculation such as % from total. | ||
+ | |||
+ | **Example** | ||
+ | |||
+ | Table A | ||
+ | ^Province | ||
+ | |All | 4500| | ||
+ | |||
+ | Table B (before transformation) | ||
+ | ^Province | ||
+ | |Ontario | ||
+ | |British Columbia | ||
+ | |Quebec | ||
+ | |||
+ | Table B (after transformation) | ||
+ | ^Province | ||
+ | |Ontario | ||
+ | |British Columbia | ||
+ | |Quebec | ||
+ |
transformations/peek.txt · Last modified: 2021/07/19 01:48 by craigt