XLS Format Collector

Iteratively merges and stores XLS Formatter model settings within a loop

This is used in conjunction with an XLS Format Retriever component. The Collector is placed within a LOOP and stores the collected XLS Format models with each loop iteration.

The XLS Format Retriever is placed after the LOOP END, and collectors the stored XLS Formatter model so that it can be passed to the XLS Format (Apply) node, or other XLS Format nodes.


@takbb Brian Bates 09 October 2022

Options

Persist model to workflow storage
This should generally be selected to persist the workflow to storage. The only reason for setting it to false is if the intention is that this component be used conditionally. %%00010%%00010%%00010Unfortunately there is a bug in KNIME where placing a component in a switch/if statement causes the component to execute and make its branch active regardless of the actual active branch. %%00010%%00010So instead set this value rather than placing the component inside a conditional branch
Choose loop counter (iteration) variable
Choose the loop variable that provides the iteration count. This must be an iteration varialble that starts at 0 indicating the first iteration of the loop, as this is used to track the iterations.
Collector Name
Enter a name for this collector that is unique to this workflow. You only need to change this if you have more than one collector in your workflow

Input Ports

Icon
Flow variables, which must contain the current iteration counter within a loop. For the first iteration of the loop, the iteration variable must be 0
Icon
The XLS Format model to be stored on this iteration of the loop

Output Ports

This node has no output ports

Nodes

Extensions

Links