transformations:peek
This is an old revision of the document!
Peek
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.1443752871.txt.gz · Last modified: by dmitry