Differences

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

--- transformations:peek [2015/10/01 22:27] – dmitry
+++ transformations:peek [2021/03/23 23:20] – craigt
@@ Line 1: / Line 1: @@
-===== Peek =====
+{{ transformations:PeekAction.png}}
+====== PEEK ======
+Category: Transform / Basic
-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.
+=====Description=====
+This action takes a value from another table and creates a new column populated with this value. \\
-**Example**
+\\
+=====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:  //Row #// (select the specific row number the valued resides in) and\\ //Last row// (pull the value from the last row in the column).|
-Table A
+\\
+=====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  ^Total Amount  ^
 |All  | 	      4500|
-Table B (before transformation)
+**Table B:** (before transformation)
 ^Province  ^Amount  ^
 |Ontario  | 	1000|
@@ Line 15: / Line 30: @@
 |Quebec  |    	2000|
-Table B (after transformation)
+**Transformation parameters:**
+>  Peek from Table A
+>  From column Total Amount
+>  Row # 1
+**Table B:** (after transformation)
 ^Province  ^Amount  ^Total Amount  ^
 |Ontario  | 	1000| 	 4500|
 |British Columbia  | 	1500|	 4500|
 |Quebec  |    	2000|	 4500|
+\\
+=====See also=====
+  *[[transformations:append|Append another table]]
+  *[[transformations:merge|Merge another table]]