| Both sides previous revisionPrevious revisionNext revision | Previous revision |
| transformations:iteratetable [2021/06/06 23:47] – craigt | transformations:iteratetable [2021/07/17 15:58] (current) – [See also] craigt |
|---|
| \\ | \\ |
| =====Description===== | =====Description===== |
| This action is similar to [[transformations:iterate|Iterate]] action, but allows passing a table to an iterated project. //Iterate table// has two inputs: | This action is similar to [[transformations:iterate|Iterate]] action but allows passing a table to an iterated project. //Iterate table// has two inputs: |
| |
| - The output of the previous action | - The output of the previous action |
| =====Action settings===== | =====Action settings===== |
| ^Setting^Description^ | ^Setting^Description^ |
| | |Other table|Select the table from the current project that will be passed into the called module (or project).| |
| |Module/Project to run<sup>*</sup>|Select whether to call a module (within the current project), or an external project (.morph file), then select the\\ module, or browse to the project file.| | |Module/Project to run<sup>*</sup>|Select whether to call a module (within the current project), or an external project (.morph file), then select the\\ module, or browse to the project file.| |
| |Column name|Enter the name that will be assigned to all columns as they are passed to the called module.| | |Iteration mode|Choose whether to just iterate the called module (or project) and //not// return any results, or iterate and return\\ a dataset. Options: //Iterate// or //Iterate, append results// (and select the Result table from\\ the called module or project).| |
| |Mode|Choose whether to just iterate the called module (or project) and //not// return any results, or iterate and return\\ columns. Options: //Iterate, ignore results// or //Iterate, append result columns// (and select the Result table from\\ the called module or project; returned columns will be appended side-by-side).| | |Assign parameters|Select the parameter(s) in the called module (or project) to pass values in through, and enter the associated\\ value(s)<sup>*</sup> (can be a column, text/number, or parameter).| |
| |Assign parameters|Select the parameter(s) in the called module (or project) to pass values in through, and enter the associated value(s)<sup>*</sup> (can be a column, text/number, or parameter).| | |
| |Exclude selected columns|Check to exclude selected columns from being iterated. Select the columns to be skipped and not be sent to the called module.| | |
| <sup>*</sup> Setting can be specified using a [[:parameters|parameter]].\\ | <sup>*</sup> Setting can be specified using a [[:parameters|parameter]].\\ |
| |
| |
| \\ | \\ |
| =====More examples===== | ====Community examples==== |
| * [[https://community.easymorph.com/t/create-a-new-table-with-columns-based-on-row-values/1625/3|Community: Create a new table with columns based on row values]] | * [[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: //Main//; Group: //Tab 1//; Table: //Table 1//; Action position: //4//) |
| * [[https://community.easymorph.com/t/crosstable-multiple-column-groups/1249|Community: Crosstable multiple column groups]] | * [[https://community.easymorph.com/t//1749/2|Match action - matching multiple values]] ([[https://community.easymorph.com/uploads/short-url/klCJavldZpx8EQbvoCRW6a6cYlr.morph|Project]]; Module: //Main//; Group: //Tab 1//; Table: //All matches//; Action position: //2//) |
| | * [[https://community.easymorph.com/t//2008/2|“Printed” Text File: Could EasyMorph import this?]] ([[https://community.easymorph.com/uploads/short-url/kIb1qqOJb9WK6D1N1jFZdnHzC46.morph|Project]]; Module: //Main//; Group: //Tab 1//; Table: //TIMESHEET.txt (2)//; Action position: //4//) |
| | * [[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: //Main//; Group: //Tab 1//; Table: //Table 1//; Action position: //4//) |
| |
| \\ | \\ |
| * [[transformations:input|Input]] | * [[transformations:input|Input]] |
| * [[transformations:iterate|Iterate]] | * [[transformations:iterate|Iterate]] |
| * [[transformations:iteratecolumns|Iterate column]] | * [[transformations:iteratecolumn|Iterate column]] |
| * Read [[http://easymorph.com/learn/iterations.html|Iterations and loops in EasyMorph]] for more details regarding this action. | * Read [[http://easymorph.com/learn/iterations.html|Iterations and loops in EasyMorph]] for more details regarding this action. |
| |
| |
