Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.


Info
iconfalse
titleScenario

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
iconfalse
titleExample

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.

...