Join Rows (Cartesian product)
Description
Join Rows is a step in the Joins Plugin for Process Studio Workflows. The Join rows step creates combinations (Cartesian product) of all rows in the input streams. The number of rows is the multiplication of the number of rows in the input streams.
Configurations
| No. | Field Name | Description |
|---|---|---|
| 1 | Step name | Name of the step; this name has to be unique in a single workflow |
| 2 | Temp directory | Specify the name of the directory where the system stores temporary files. This is required when you want to combine more than the cached number of rows. |
| 3 | TMP-file prefix | Specify the prefix of the temporary files that will be generated. |
| 4 | Max. cache size | Specify the maximum cache size. Only after the cache size threshold the system uses temporary files for caching data. This is required when you want to combine large row sets that do not fit into memory. |
| 6 | Main step to read from | Specify the step from which to read most of the data. The data from this step is spooled to the temporary file in disk while the data from other steps is not spooled to the file. |
| 7 | The Condition(s) | You can enter a multi-level condition to limit the number of output rows. |