Hub
Pricing About
WorkflowWorkflow

Test mandatory columns for missing values and fail on error - enhanced

takbb profile image
VersionInitialLatest, created on 
Nov 6, 2024 11:46 AM
Drag & drop
Like
Download workflow
Workflow preview

This workflow processes a series of columns in which the first row indicates if the column is mandatory or optional.

If a column is mandatory and contains any missing values, the workflow stops processing, with an error message.

This workflow demonstrates the Java Snippet's "throw Abort("message");

which will return a message to the UI and halt processing.

Enhanced version which optimises "discovery" of missing values by counting the number of non-missing values in each column and then only presenting those columns to the Column List Loop, which is now a "convenience" loop as it will abort on the first column.

@takbb Brian Bates 06 November 2024

External resources

  • Forum Question 84166
Loading deploymentsLoading ad hoc jobs

Used extensions & nodes

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

    KNIME AG, Zurich, Switzerland

    Version 5.3.2

    knime
  • Go to item
    KNIME Excel SupportTrusted extension

    KNIME AG, Zurich, Switzerland

    Version 5.3.2

    knime
  • Go to item
    KNIME JavasnippetTrusted extension

    KNIME AG, Zurich, Switzerland

    Version 5.3.0

    knime
  • Go to item
    KNIME Quick FormsTrusted extension

    KNIME AG, Zurich, Switzerland

    Version 5.3.2

    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