transformations:peek
Differences
This shows you the differences between two versions of the page.
Both sides previous revisionPrevious revisionNext revision | Previous revision | ||
transformations:peek [2021/03/29 01:25] – craigt | transformations:peek [2021/07/19 01:48] (current) – [Examples] craigt | ||
---|---|---|---|
Line 9: | Line 9: | ||
\\ | \\ | ||
=====Use cases===== | =====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 total.\\ | + | 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.\\ |
\\ | \\ | ||
Line 22: | Line 22: | ||
=====Examples===== | =====Examples===== | ||
- | **Table A:** | + | **Source table A:** |
^Province | ^Province | ||
|All | 4500| | |All | 4500| | ||
- | **Table B:** (before transformation) | + | **Source table B:** (before transformation) |
^Province | ^Province | ||
|Ontario | |Ontario | ||
|British Columbia | |British Columbia | ||
|Quebec | |Quebec | ||
+ | \\ | ||
**Action parameters: | **Action parameters: | ||
- | > Peek from Table A | + | > Peek from Source table A |
> From column Total Amount | > From column Total Amount | ||
> Row # 1 | > Row # 1 | ||
- | **Table B:** (after transformation) | + | \\ |
+ | **Result table (Source table B):** (after transformation) | ||
^Province | ^Province | ||
|Ontario | |Ontario | ||
|British Columbia | |British Columbia | ||
|Quebec | |Quebec | ||
+ | |||
+ | \\ | ||
+ | ====Community examples==== | ||
+ | * [[https:// | ||
+ | * [[https:// | ||
+ | * [[https:// | ||
\\ | \\ |
transformations/peek.txt · Last modified: 2021/07/19 01:48 by craigt