Hub
Pricing About
ComponentComponent

Interpolated Value Lookup

takbb profile image
Draft Latest edits on 
Oct 6, 2023 1:43 PM
Drag & drop
Like
Use or download
Perform a Value Lookup for a numeric value N against a dictionary table. The returned value is the "lookup" value for that dictionary item, or, if the exact value is not found, it returns the interpolated value based on the position in the table between the next lower and next upper lookup values for value N

Component details

Input ports
  1. Type: Table
    Input Table
    Table containing a value for which a lookup is required
  2. Type: Table
    Dictionary Table
    Dictionary table containing a lookup value column, and a resultant value column
Output ports
  1. Type: Table
    Result Table
    The original table plus an interpolated value for the item being looked up.

Used extensions & nodes

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

    KNIME AG, Zurich, Switzerland

    Version 5.1.1

    knime
  • Go to item
    KNIME JavasnippetTrusted extension

    KNIME AG, Zurich, Switzerland

    Version 5.1.0

    knime
  • Go to item
    KNIME Math Expression (JEP)Trusted extension

    KNIME AG, Zurich, Switzerland

    Version 5.1.0

    knime
  • Go to item
    KNIME Quick FormsTrusted extension

    KNIME AG, Zurich, Switzerland

    Version 5.1.1

    knime

This component does not have nodes, extensions, nested components and related workflows

Legal

By using or downloading the component, 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