Hub
  • Software
  • Blog
  • Forum
  • Events
  • Documentation
  • About KNIME
  • KNIME Hub
  • takbb
  • Spaces
  • Public
  • Blank Non-Significant Values
ComponentComponent

Blank Non-Significant Values

Last edited: 

Drag & drop
Like
Use or download
Copy short link
Tracks one column within a grouping, and blanks another column where the tracking column has no further significant (non-zero) values. It can also perform blanking up to the first non-zero encountered. Specify a single column against which data is to be grouped. (If grouping with more than one column is required, simply concatenate the required columns into a single "grouping" column. Specify a second column to be tracked for significant values. The last non-zero value within any group is considered the last significant value in this column for that group. Specify a third column (which could also be the tracked column) which is to have its value set to Missing from the point at which there are no further significant values in the tracked column. May 15th 2021 @takbb Brian Bates

Component details

Input ports
  1. Type: Table
    Data, already sorted into the required order for processing by group
Output ports
  1. Type: Table
    Evaluated Data
    Data as supplied but with additional boolean columns FIRST_IN_GROUP and LAST_IN_GROUP

Used extensions & nodes

Created with KNIME Analytics Platform version 4.3.2
  • Go to item
    KNIME Base nodes Trusted extension

    KNIME AG, Zurich, Switzerland

    Version 4.3.2

  • Go to item
    KNIME Data Generation Trusted extension

    KNIME AG, Zurich, Switzerland

    Version 4.3.0

  • Go to item
    KNIME Expressions Trusted extension

    KNIME AG, Zurich, Switzerland

    Version 4.3.0

  • Go to item
    KNIME Javasnippet Trusted extension

    KNIME AG, Zurich, Switzerland

    Version 4.3.0

  • Go to item
    KNIME Quick Forms Trusted extension

    KNIME AG, Zurich, Switzerland

    Version 4.3.2

  1. Go to item
  2. Go to item
  3. Go to item
  4. Go to item
  5. Go to item
  6. Go to item

Legal

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

KNIME
Open for Innovation

KNIME AG
Hardturmstrasse 66
8005 Zurich, Switzerland
  • Software
  • Getting started
  • Documentation
  • E-Learning course
  • Solutions
  • KNIME Hub
  • KNIME Forum
  • Blog
  • Events
  • Partner
  • Developers
  • KNIME Home
  • KNIME Open Source Story
  • Careers
  • Contact us
Download KNIME Analytics Platform Read more on KNIME Server
© 2022 KNIME AG. All rights reserved.
  • Trademarks
  • Imprint
  • Privacy
  • Terms & Conditions
  • Credits