Differences

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

--- transformations:peek [2021/03/23 23:20] – craigt
+++ transformations:peek [2021/03/29 01:25] – craigt
@@ Line 1: / Line 1: @@
 {{ transformations:PeekAction.png}}
 ====== PEEK ======
-Category: Transform / Basic
+Category: Transform / Basic\\
+\\
 =====Description=====
 This action takes a value from another table and creates a new column populated with this value. \\
+\\
+=====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.\\
 \\
@@ Line 11: / Line 16: @@
 |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:  //Row #// (select the specific row number the valued resides in) and\\ //Last row// (pull the value from the last row in the column).|
+|From|Input the row the value resides in.  Options:  //Row #<sup>*</sup>// (select the specific row number the valued resides in) and\\ //Last row// (pull the value from the last row in the column).|
+<sup>*</sup> Setting can be specified using a [[:parameters|parameter]].\\
-\\
-=====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.\\
 \\
@@ Line 30: / Line 32: @@
 |Quebec  |    	2000|
-**Transformation parameters:**
+**Action parameters:**
 >  Peek from Table A
 >  From column Total Amount