User Tools

Site Tools


transformations:peek

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.txt · Last modified: 2015/10/02 02:27 by dmitry