Icon

Streaming Lookup

A workaround for joining two tables in streaming mode.

If joins are only used to look up additional information (e.g., a year or a name) on a key (e.g., a personidentifier), a cell replacer can be used instead. The solution is somewhat cumbersome but has theadvantage that it allows parallelization through streaming - which the joiner does not support. Lookup TableBase tableLooks up the person data matching the person_id fields in the base table Table Creator Table Creator Streaming Lookup If joins are only used to look up additional information (e.g., a year or a name) on a key (e.g., a personidentifier), a cell replacer can be used instead. The solution is somewhat cumbersome but has theadvantage that it allows parallelization through streaming - which the joiner does not support. Lookup TableBase tableLooks up the person data matching the person_id fields in the base table Table Creator Table Creator Streaming Lookup

Nodes

Extensions

Links

Download

To use this workflow in KNIME, download it from the below URL and open it in KNIME:

Download Workflow
Created by: carlwitt
Created at: 2022-02-15
On NodePit since: 2022-02-18
Last update: 2024-04-26
Created with KNIME version: v4.6.0 nightly

Deploy, schedule, execute, and monitor your KNIME workflows locally, in the cloud or on-premises – with our brand new NodePit Runner.

Try NodePit Runner!