transformations:peek
Differences
This shows you the differences between two versions of the page.
Next revision | Previous revisionNext revisionBoth sides next revision | ||
transformations:peek [2015/10/01 22:21] – created dmitry | transformations:peek [2021/03/23 23:20] – craigt | ||
---|---|---|---|
Line 1: | Line 1: | ||
- | ===== Peek ===== | + | {{ transformations: |
+ | ====== PEEK ====== | ||
+ | Category: Transform / Basic | ||
+ | |||
+ | =====Description===== | ||
+ | This action takes a value from another table and creates a new column populated with this value. \\ | ||
+ | |||
+ | \\ | ||
+ | =====Action settings===== | ||
+ | ^Setting^Description^ | ||
+ | |Peek from table|Select the table the value resides in. | | ||
+ | |From column|Select the column the value resides in.| | ||
+ | |From|Input the row the value resides in. Options: | ||
+ | |||
+ | \\ | ||
+ | =====Use cases===== | ||
+ | A typical use case for this action would be bringing in some total value from another table for further calculation such as % from total.\\ | ||
+ | |||
+ | \\ | ||
+ | =====Examples===== | ||
+ | |||
+ | **Table A:** | ||
+ | ^Province | ||
+ | |All | 4500| | ||
+ | |||
+ | **Table B:** (before transformation) | ||
+ | ^Province | ||
+ | |Ontario | ||
+ | |British Columbia | ||
+ | |Quebec | ||
+ | |||
+ | **Transformation parameters: | ||
+ | > Peek from Table A | ||
+ | > From column Total Amount | ||
+ | > Row # 1 | ||
+ | |||
+ | **Table B:** (after transformation) | ||
+ | ^Province | ||
+ | |Ontario | ||
+ | |British Columbia | ||
+ | |Quebec | ||
+ | |||
+ | \\ | ||
+ | =====See also===== | ||
+ | *[[transformations: | ||
+ | *[[transformations: | ||
- | 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. |
transformations/peek.txt · Last modified: 2021/07/19 01:48 by craigt