Info | ||||
---|---|---|---|---|
| ||||
Combining a large stream with data from a small stream, where the values of the very small stream will be repeated throughout the result. For each pair of matching records from the data sets, a single record is produced in the output. |
Info | ||||
---|---|---|---|---|
| ||||
Find the description for each code in a stream of thousands from a stream containing mapping data. There are only ~100 possible codes. |
To do this, use a calculate stream with an order/index lookup pipe.
In the below screenshot, 'Source Stream 1' about 2000 records and we want to enrich this data with data from 'Source Stream 2', which contains about 50 records.
...