transformations:peek
Differences
This shows you the differences between two versions of the page.
|
transformations:peek [2015/10/02 02:21] dmitry created |
transformations:peek [2015/10/02 02:27] (current) 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 ^Total Amount ^ | ||
| + | |All | 4500| | ||
| + | |||
| + | Table B (before transformation) | ||
| + | ^Province ^Amount ^ | ||
| + | |Ontario | 1000| | ||
| + | |British Columbia | 1500| | ||
| + | |Quebec | 2000| | ||
| + | |||
| + | Table B (after transformation) | ||
| + | ^Province ^Amount ^Total Amount ^ | ||
| + | |Ontario | 1000| 4500| | ||
| + | |British Columbia | 1500| 4500| | ||
| + | |Quebec | 2000| 4500| | ||
| + | |||
transformations/peek.txt · Last modified: 2015/10/02 02:27 by dmitry
Page Tools
