Differences

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

--- transformations:input [2016/09/20 22:58] – dmitry
+++ transformations:input [2021/07/18 02:03] (current) – craigt
@@ 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 works together with the [[transformations:call|Call]], [[transformations:iterate|Iterate]], [[transformations:iteratecolumn|Iterate column]], [[transformations:iteratetable|Iterate table]], or [[transformations:repeat|Repeat]] actions. It obtains an input dataset from the module (or project) that called current module. If the current module was not called from another module (or project) then Input returns empty dataset.\\
-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.
+\\
+=====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.\\
-**See also**
+\\
+=====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.|
+====Externally====
+^Option^Description^
+|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=====
+To simplify development, it is possible to 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.\\
+An Input action called from another project cannot be //automatically// populated with test data.  Either a .dset file export must be made from the calling dataset and imported into the Input action, or, the calling 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:call|Call]]
+  * [[transformations:iterate|Iterate]]
+  * [[transformations: iteratecolumn|Iterate column]]
   * [[transformations:iteratetable|Iterate table]]
+  * [[transformations:iterateprogram|Iterate external program]]