User Tools

Site Tools


transformations:peek

Differences

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

Link to this comparison view

Both sides previous revisionPrevious revision
Next revision
Previous revision
Last revisionBoth sides next revision
transformations:peek [2021/03/23 23:20] craigttransformations:peek [2021/07/17 16:22] craigt
Line 1: Line 1:
 {{ transformations:PeekAction.png}} {{ transformations:PeekAction.png}}
 ====== PEEK ====== ====== PEEK ======
-Category: Transform / Basic+Category: Transform / Basic\\
  
 +\\ 
 =====Description===== =====Description=====
 This action takes a value from another table and creates a new column populated with this value. \\ 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. | |Peek from table|Select the table the value resides in. |
 |From column|Select the column 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| |Quebec  |    2000|
  
-**Transformation parameters:**+**Action parameters:**
 >  Peek from Table A >  Peek from Table A
 >  From column Total Amount >  From column Total Amount
Line 40: Line 42:
 |British Columbia  | 1500| 4500| |British Columbia  | 1500| 4500|
 |Quebec  |    2000| 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//)
  
 \\  \\ 
transformations/peek.txt · Last modified: 2021/07/19 01:48 by craigt

Donate Powered by PHP Valid HTML5 Valid CSS Driven by DokuWiki