Differences

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

--- transformations:peek [2021/03/23 23:20] – craigt
+++ transformations:peek [2021/07/19 01:48] (current) – [Examples] 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 the 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.\\
 \\
 =====Examples=====
-**Table A:**
+**Source table A:**
 ^Province  ^Total Amount  ^
 |All  | 	      4500|
-**Table B:** (before transformation)
+**Source table B:** (before transformation)
 ^Province  ^Amount  ^
 |Ontario  | 	1000|
 |British Columbia  | 	1500|
 |Quebec  |    	2000|
+\\
-**Transformation parameters:**
+**Action parameters:**
->  Peek from Table A
+>  Peek from Source table A
 >  From column Total Amount
 >  Row # 1
-**Table B:** (after transformation)
+\\
+**Result table (Source table B):** (after transformation)
 ^Province  ^Amount  ^Total Amount  ^
 |Ontario  | 	1000| 	 4500|
 |British Columbia  | 	1500|	 4500|
 |Quebec  |    	2000|	 4500|
+\\
+====Community examples====
+  * [[https://community.easymorph.com/t//1850/1|Process a group of files only when all of them are present]] ([[https://community.easymorph.com/uploads/short-url/zJqXVSbMintqzS3bYdfpLMj9c45.morph|Project]]; Module: //Main//; Group: //Tab 1//; Table: //Table 1//; Action position: //2//)
+  * [[https://community.easymorph.com/t//2160/1|How to pull data from web APIs with pagination]] ([[https://community.easymorph.com/uploads/short-url/dvCSpcEDXYZ8aB0B2gtnt7qulTF.morph|Project]]; Module: //Query API//; Group: //Group 1//; Table: //Query//; Action position: //5//)
+  * [[https://community.easymorph.com/t//2306/7|Ideas for generating random password strings?]] ([[https://community.easymorph.com/uploads/short-url/lJo9Cm9I7zuTvfLiw9pMHmwoUHs.morph|Project]]; Module: //Main//; Group: //Group 1//; Table: //Generator//; Action position: //2//)
 \\