transformations:peek
Differences
This shows you the differences between two versions of the page.
Both sides previous revisionPrevious revisionNext revision | Previous revision | ||
transformations:peek [2015/10/01 22:27] – dmitry | transformations:peek [2025/01/10 11:25] (current) – craigt | ||
---|---|---|---|
Line 1: | Line 1: | ||
- | ===== Peek ===== | + | {{ transformations: |
+ | ====== | ||
+ | Category: Transform / Basic\\ | ||
- | This transformation | + | \\ |
+ | =====Description===== | ||
+ | This action | ||
- | **Example** | + | \\ |
+ | =====Use cases===== | ||
+ | A typical use case for this action would be bringing in a total value from another table for further calculation - such as % from the total.\\ | ||
- | Table A | + | \\ |
+ | =====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: | ||
+ | < | ||
+ | |||
+ | \\ | ||
+ | =====Examples===== | ||
+ | |||
+ | ====Example #1==== | ||
+ | >Append Total amount to each row in Table 2 | ||
+ | |||
+ | ===Before (source table)=== | ||
+ | Table 1: Total amount value | ||
^Province | ^Province | ||
|All | 4500| | |All | 4500| | ||
- | Table B (before transformation) | + | Table 2: Provincial expenses |
^Province | ^Province | ||
|Ontario | |Ontario | ||
Line 15: | Line 36: | ||
|Quebec | |Quebec | ||
- | Table B (after transformation) | + | ===After |
^Province | ^Province | ||
- | |Ontario | + | |Ontario |
- | |British Columbia | + | |British Columbia |
- | |Quebec | + | |Quebec |
+ | |||
+ | |||
+ | ===Action parameters=== | ||
+ | > Peek from Source table A | ||
+ | > From column Total Amount | ||
+ | > Row # 1 | ||
+ | |||
+ | |||
+ | \\ | ||
+ | =====Community examples===== | ||
+ | * [[https:// | ||
+ | * [[https:// | ||
+ | * [[https:// | ||
+ | |||
+ | \\ | ||
+ | =====See also===== | ||
+ | *[[transformations: | ||
+ | *[[transformations: | ||
transformations/peek.1443752871.txt.gz · Last modified: 2015/10/01 22:27 by dmitry