Hub
Pricing About
WorkflowWorkflow

ToolValueLookup

Ai agentAgentic aiTools
knime profile image
Versionv1.0Latest, created on 
Jul 21, 2025 3:16 PM
Drag & drop
Like
Download workflow
Workflow preview

Tool - Value Lookup

This tool enriches a data table by matching values from a reference (dictionary) table. You provide two tables: the data table to be enriched and the dictionary table with reference info. Choose one column from the data table and one from the dictionary table to match on. When a match is found, all columns from the matching dictionary row are added to the data row. Examples:

Customer Info: Match customer IDs in the data table with a dictionary of customer names and emails. The tool adds name and email to each row.

Product Lookup: Match product codes from sales data with a dictionary of descriptions and prices. The tool appends product details.

Region Mapping: Match ZIP codes with a dictionary of regions. The tool adds region and territory info to each row.

Loading deploymentsLoading ad hoc jobs

Used extensions & nodes

Created with KNIME Analytics Platform version 5.5.0
  • Go to item
    KNIME Base nodesTrusted extension

    KNIME AG, Zurich, Switzerland

    Version 5.5.0

    knime profile image
    knime
  • Go to item
    KNIME ExpressionsTrusted extension

    KNIME AG, Zurich, Switzerland

    Version 5.5.0

    knime profile image
    knime
  • Go to item
    KNIME Personal Productivity ToolsTrusted extension

    KNIME AG, Zurich, Switzerland

    Version 5.5.0

    knime profile image
    knime
  • Go to item
    KNIME Quick FormsTrusted extension

    KNIME AG, Zurich, Switzerland

    Version 5.5.0

    knime profile image
    knime

Legal

By using or downloading the workflow, you agree to our terms and conditions.

KNIME
Open for Innovation

KNIME AG
Talacker 50
8001 Zurich, Switzerland
  • Software
  • Getting started
  • Documentation
  • Courses + Certification
  • Solutions
  • KNIME Hub
  • KNIME Forum
  • Blog
  • Events
  • Partner
  • Developers
  • KNIME Home
  • Careers
  • Contact us
Download KNIME Analytics Platform Read more about KNIME Business Hub
© 2025 KNIME AG. All rights reserved.
  • Trademarks
  • Imprint
  • Privacy
  • Terms & Conditions
  • Data Processing Agreement
  • Credits