User Tools

Site Tools


transformations:peek

Differences

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

Link to this comparison view

Next revisionBoth sides next revision
transformations:peek [2015/10/01 22:21] – created dmitrytransformations:peek [2015/10/01 22:27] 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: 2021/07/19 01:48 by craigt

Donate Powered by PHP Valid HTML5 Valid CSS Driven by DokuWiki