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: 2015/10/01 22:27 by dmitry