User Tools

Site Tools


transformations:peek

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

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