Hub
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.

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:

Related workflows & nodes

  1. 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. Database Manipulation 2
    danielbg > Public > Database Manipulation 2
    danielbg
  3. 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
  4. 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
  5. 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
  6. 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
  7. 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
  8. 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
    hayasaka
  9. Databases - Advanced Usage
    Database Sqlite
    This workflow shows a KNIME workflow with a number of database nodes that directly work i…
    knime > Examples > 01_Data_Access > 02_Databases > 02_Database_Advanced_Example
    rs1
  10. 03 DB Modelling Exercise
    Big Data Education
    Big Data Course DB Exercise #3
    knime > Education > Courses > L4-BD Introduction to Big Data with KNIME Analytics Platform > 1_DB > 2_Exercises > 03_DB_Modelling
    knime