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
transformations:peek [2015/10/01 22:27] dmitrytransformations:peek [2025/01/10 11:25] (current) 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**+\\ 
 +=====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.\\
  
-Table A+\\  
 +=====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 #<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]].\\ 
 + 
 +\\  
 +=====Examples===== 
 + 
 +====Example #1====  
 +>Append Total amount to each row in Table 
 + 
 +===Before (source table)=== 
 +Table 1: Total amount value
 ^Province  ^Total Amount  ^ ^Province  ^Total Amount  ^
 |All  |       4500| |All  |       4500|
  
-Table B (before transformation)+Table 2: Provincial expenses
 ^Province  ^Amount  ^ ^Province  ^Amount  ^
 |Ontario  | 1000| |Ontario  | 1000|
Line 15: Line 36:
 |Quebec  |    2000| |Quebec  |    2000|
  
-Table B (after transformation)+===After (result table)===
 ^Province  ^Amount  ^Total Amount  ^ ^Province  ^Amount  ^Total Amount  ^
-|Ontario  | 1000| 4500| +|Ontario  | 1000|  **4500**
-|British Columbia  | 1500| 4500| +|British Columbia  | 1500|  **4500**
-|Quebec  |    2000| 4500|+|Quebec  |    2000|  **4500**| 
 + 
 + 
 +===Action parameters=== 
 +>  Peek from Source table A 
 +>  From column Total Amount 
 +>  Row # 1 
 + 
 + 
 +\\  
 +=====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//) 
 + 
 +\\  
 +=====See also===== 
 +  *[[transformations:append|Append another table]] 
 +  *[[transformations:merge|Merge another table]]
  
transformations/peek.1443752871.txt.gz · Last modified: 2015/10/01 22:27 by dmitry

Donate Powered by PHP Valid HTML5 Valid CSS Driven by DokuWiki