Hub
Pricing About
  • Software
  • Blog
  • Forum
  • Events
  • Documentation
  • About KNIME
  • KNIME Community Hub
  • Nodes
  • DB Column Filter
NodeNode / Manipulator

DB Column Filter

DB Query
Drag & drop
Like
Copy short link

This node allows columns to be filtered from the input DB Data object so that the SQL result will only contain the remaining columns. Within the dialog, columns can be moved between the Include and Exclude lists.

External resources

  • KNIME E-Learning Course: Column Filter
  • Java API documentation about regex patterns
  • Java API documentation about regex matching

Node details

Input ports
  1. Type: DB Data
    DB Data
    DB Data with columns to include/exclude.
Output ports
  1. Type: DB Data
    Filtered DB Data
    Input DB Data with filtered columns.

Extension

The DB Column Filter node is part of this extension:

  1. Go to item

Related workflows & nodes

  1. Go to item
    Fetch Data from Database
    Life Sciences Database SQLite
    This example workflow shows how to retrieve data from SQLite database. Specifically, it s…
    knime > Workflow Snippets > Fetch_Data_from_Database
    knime
  2. Go to item
    Database Manipulation 2
    danielbg > Public > Database Manipulation 2
    danielbg
  3. Go to item
    Database
    Database Database preprocessing Education
    +2
    Solution to "Database" exercise for basic Life Science User Training - Writing data into …
    knime > Education > Courses > L1-LS KNIME Analytics Platform for Data Scientists - Life Sciences - Basics > Solutions > 05. Database - solution
    knime
  4. Go to item
    Database
    Database Database preprocessing Education
    +2
    "Database" exercise for basic Life Science User Training - Writing data into a database -…
    catherineoleary > Public > L1-LS KNIME Analytics Platform for Data Scientists - Life Sciences - Basics > Exercises > 05. Database
    catherineoleary
  5. Go to item
    Database
    Database Database preprocessing Education
    +2
    Solution to "Database" exercise for basic Life Science User Training - Writing data into …
    ciaccindr > Public > Corso2022 > L1-LS > Solutions > 05. Database - solution
    ciaccindr
  6. Go to item
    Database
    Database Database preprocessing Education
    +2
    Solution to "Database" exercise for basic Life Science User Training - Writing data into …
    janina > Customized Training > Customized Training - Life Sciences > Solutions > 05. Database - solution
    janina
  7. Go to item
    Database
    Database Database preprocessing Education
    +2
    Solution to "Database" exercise for basic Life Science User Training - Writing data into …
    catherineoleary > Public > L1-LS KNIME Analytics Platform for Data Scientists - Life Sciences - Basics > Solutions > 05. Database - solution
    catherineoleary
  8. Go to item
    Database
    Database Database preprocessing Education
    +2
    Solution to "Database" exercise for basic Life Science User Training - Writing data into …
    pau22nanda > Public > L1-LS KNIME Analytics Platform for Data Scientists - Life Sciences - Basics > Solutions > 05. Database - solution
    pau22nanda
  9. Go to item
    Database
    Database Database preprocessing Education
    +2
    Solution to "Database" exercise for basic Life Science User Training - Writing data into …
    ioneliad > Public > ID_Workflow_Group > L1-LS KNIME Analytics Platform for Data Scientists - Life Sciences - Basics > Solutions > 05. Database - solution
    ioneliad
  10. Go to item
    Database
    Database Database preprocessing Education
    +2
    Solution to "Database" exercise for basic Life Science User Training - Writing data into …
    ioneliad > Public > ID_Workflow_Group > L1-DS KNIME Analytics Platform for Data Scientists - Basics > L1-LS KNIME Analytics Platform for Data Scientists - Life Sciences - Basics > Solutions > 05. Database - solution
    ioneliad
  1. Go to item
  2. Go to item

KNIME
Open for Innovation

KNIME AG
Talacker 50
8001 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 Business Hub
© 2023 KNIME AG. All rights reserved.
  • Trademarks
  • Imprint
  • Privacy
  • Terms & Conditions
  • Credits