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 [2021/03/29 01:25] craigttransformations:peek [2021/07/19 01:48] (current) – [Examples] craigt
Line 9: Line 9:
 \\ \\
 =====Use cases===== =====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.\\+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 22: Line 22:
 =====Examples===== =====Examples=====
  
-**Table A:**+**Source table A:**
 ^Province  ^Total Amount  ^ ^Province  ^Total Amount  ^
 |All  |       4500| |All  |       4500|
  
-**Table B:** (before transformation)+**Source table B:** (before transformation)
 ^Province  ^Amount  ^ ^Province  ^Amount  ^
 |Ontario  | 1000| |Ontario  | 1000|
 |British Columbia  | 1500| |British Columbia  | 1500|
 |Quebec  |    2000| |Quebec  |    2000|
 +\\ 
 **Action parameters:** **Action parameters:**
->  Peek from Table A+>  Peek from Source table A
 >  From column Total Amount >  From column Total Amount
 >  Row # 1 >  Row # 1
  
-**Table B:** (after transformation)+\\  
 +**Result table (Source table B):** (after transformation)
 ^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|
 +
 +\\ 
 +====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