transformations:iteratetable
Differences
This shows you the differences between two versions of the page.
Both sides previous revisionPrevious revisionNext revision | Previous revisionNext revisionBoth sides next revision | ||
transformations:iteratetable [2020/02/06 04:47] – dmitry | transformations:iteratetable [2021/06/06 23:47] – craigt | ||
---|---|---|---|
Line 1: | Line 1: | ||
- | ===== Iterate table ===== | + | {{ transformations: |
+ | ====== | ||
+ | Category: Workflow / Internal \\ | ||
- | This action is similar to [[transformations: | + | \\ |
+ | =====Description===== | ||
+ | This action is similar to [[transformations: | ||
- | 1. The output of the previous action | + | |
- | 2. The external table it references | + | - The external table passed into the called module/ |
- | The action works as follows: | + | This action works as follows: |
- | The iterated project should use [[transformations: | + | The iterated |
+ | |||
+ | \\ | ||
+ | =====Use cases===== | ||
+ | This action is helpful when multiple calculations with different parameters have to be performed on the same dataset (e.g. financial stress testing).\\ | ||
+ | |||
+ | \\ | ||
+ | =====Action settings===== | ||
+ | ^Setting^Description^ | ||
+ | |Module/ | ||
+ | |Column name|Enter the name that will be assigned to all columns as they are passed to the called module.| | ||
+ | |Mode|Choose whether to just iterate the called module (or project) and //not// return any results, or iterate and return\\ columns. | ||
+ | |Assign parameters|Select the parameter(s) in the called module (or project) to pass values in through, and enter the associated value(s)< | ||
+ | |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.| | ||
+ | < | ||
+ | |||
+ | \\ | ||
+ | =====Remarks===== | ||
+ | This action provides significantly increased performance in cases when the iterated project needs to operate with the same dataset in each iteration.\\ | ||
+ | |||
+ | |||
+ | \\ | ||
+ | =====Examples===== | ||
+ | **Mode: | ||
+ | {{ https:// | ||
+ | **Mode: | ||
+ | |||
+ | \\ | ||
+ | =====More examples===== | ||
+ | * [[https:// | ||
+ | * [[https:// | ||
+ | |||
+ | \\ | ||
+ | =====See also===== | ||
+ | * [[transformations: | ||
+ | * [[transformations: | ||
+ | * [[transformations: | ||
+ | * Read [[http:// | ||
- | This action allows significantly increasing performance in cases when iterated project had to operate with the same dataset in each iteration. | ||
- | === See also === | ||
- | [[transformations: | ||
- | [[transformations: |
transformations/iteratetable.txt · Last modified: 2021/07/17 15:58 by craigt