Differences

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

--- transformations:input [2016/09/20 22:58] – dmitry
+++ transformations:input [2025/03/01 09:49] (current) – dmitry
@@ Line 1: / Line 1: @@
-===== Input =====
+{{ transformations:InputAction.png}}
+====== INPUT ======
+Category: Create / Input\\
-This transformation works together with [[transformations:call|Call]] or [[transformations:iteratetable|Iterate table]] transformation. It obtains input dataset of such transformation of the other project that called current project. If current project was not called from another project then Input returns empty dataset.
+\\
+=====Description=====
+This action obtains an input dataset from the module (or project) that called the current module. If the current module was not called from another module (or project) then Input returns an empty dataset. This action works together with the following actions:
+  * [[transformations:callwithanothertable|Call with another table]]
+  * [[transformations:iteratecolumn|Iterate column]]
+  * [[transformations:iteratetable|Iterate table]]
+  * [[transformations:repeat|Repeat]]
+\\
+=====Use cases=====
+The Input action passes data between modules in memory which helps avoid potentially slow reading datasets from disk or writing to disk in every iteration or call. By removing the need to read/write datasets to disk, the action simplified workflows.\\
-To simplify development, it is possible to paste test data from the clipboard into Input transformation, similarly to [[transformations:sandbox|Sandbox]] transformation. Typically, a small subset is pasted and then used for designing transformation. The pasted data is not saved and doesn't survive project re-opening.
+\\
+=====Action settings=====
+====Populating the Input dataset from within the same project====
+===Within the Input action===
+^Option^Description^
+|Populate automatically|This option will attempt to retrieve data from a Call or Iterate... action within the same project.|
+|Paste data|This option will paste data that has been copied to the clipboard.  Options for //headers//, //delimiters//, and //decimal//\\ provide fine-tuning of the pasted data.|
+|Import dataset|This option allows for browsing to and selecting an external dataset (.dset file) to populate the Input action with.|
-**See also**
+===Externally===
-  * [[transformations:call|Call]]
+^Option^Description^
-  * [[transformations:iteratetable|Iterate table]]
+|Send to //module//|Data can be sent to the Input action by right-clicking on an action that produces data in the calling module and selecting\\ //Send to sandbox/module//. Select the module containing the Input action from the list at the bottom of the menu.|
+|Send to clipboard|Data can be sent to the clipboard by right-clicking on an action that produces data in the calling module and selecting\\ //Send to sandbox/module// and choosing //Send to Clipboard//.  From the Input action, choose the //Paste data// option.|
+\\
+=====Remarks=====
+When editing a workflow, the Input action is empty by default. For development and debugging, it is possible to populate the action with a sample dataset by pressing the "Populate" action in the action settings - it will find a calling action, and copy its dataset to the Input action.
+You can also paste test data from the clipboard into Input action, similar to the [[transformations:sandbox|Sandbox]] action. Typically, a small subset is pasted for use in designing the workflow. The pasted data is not saved and does not survive project re-opening.\\
+Note that an Input action called from another //project// (not a module!) cannot be automatically populated with test data.  Either a .dset file export must be made from the calling action and imported into the Input action, or the calling action's input dataset must be copied to the clipboard and pasted into the receiving Input action.\\
+\\
+=====Community examples=====
+  * [[https://community.easymorph.com/t//1625/4|Create a new table with columns based on row values]] ([[https://community.easymorph.com/uploads/short-url/4oGLUNDHrUfB971H80ciuOAtOTG.morph|Project]]; Module: //Module 1//; Group: //Tab 1//; Table: //Table 1//; Action position: //1//)
+  * [[https://community.easymorph.com/t//1749/2|Match action - matching multiple values]] ([[https://community.easymorph.com/uploads/short-url/klCJavldZpx8EQbvoCRW6a6cYlr.morph|Project]]; Module: //Get matches//; Group: //Tab 1//; Table: //Lookup table//; Action position: //1//)
+  * [[https://community.easymorph.com/t//1870/4|Send email - Add table extract to outlook email message]] ([[https://community.easymorph.com/uploads/short-url/xnfDuDCTN6iJgA4pEcQQsRIZET3.morph|Project]]; Module: //Calc column width//; Group: //Tab 1//; Table: //Table 1//;\\ Action position: //1//)
+  * [[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: //Input//; Action position: //1//)
+\\
+=====See also=====
+  * [[transformations:callwithanothertable|Call with another table]]
+  * [[transformations: iteratecolumn|Iterate column]]
+  * [[transformations:iteratetable|Iterate table]]
+  * [[transformations:repeat|Repeat]]
+  * [[transformations:sandbox|Sandbox]]