workflow-filter
An important directive in workflow iteration; it filters out all input except that the values under the header columns in its worksheet
The directive workflow-filter allows the user to specify the key values for all input worksheets in that workflow.
workflow-filter can be used with both workflow-iterate and workflow-terminate
pebblestream:workflow-filter
Filtering input during iteration can lead to improved performance.Flow will index all input in accordance with the filter specifications, resulting in less data being pushed in and out of the workflow per iteration.
The following table illustrates how this works:
| period | partnership | partner type |
|---|---|---|
| 1 | Goldman Sachs | limited |
If the workflow-filter directive is placed on a worksheet in an iteration pebble that evaluates to these values for the given workflow, for any and all input sheets that have all of these columns, only rows that have period 1, partnership Goldman Sachs, and partner type limited will be sent to the workflow for processing.
If your worksheet has more than one row, then the filter is applied as an OR. For example the following table will also include records for the general partners in the first period of the partnership Goldman Sachs as well as limited partners.
| period | partnership | partner type |
|---|---|---|
| 1 | Goldman Sachs | limited |
| 1 | Goldman Sachs | general |
Look at the examples below:
Updated 20 days ago

