Icon

kn_​forum_​36416_​table_​parameters

example demonstrating how to manually enter a selected table and columns - or provide them via a configuation file

example demonstrating how to manually enter a selected table and columns - or provide them via a configuation file


THX to KNIME for providing some initial inspirations about components ...

example demonstrating how to manually enter a selected table and columns - or provide them via a configuation file table_to_select: table_20columns_to_select: "t_20_Cluster_Membership", "t_20_Universe_0_2", "t_20_Universe_1_1" Read existing tables=> select thetable you want(right click and "Execute and Open View")to list alldatabses might vary fromDB to DBLIMIT 10/data/my_database.h2.mv.dbH2 databseextract the column namesColumn Namethe columns fromthe table you selected(right click and "Execute and Open View")configuration_file.txtthe columns fromthe table you selectedsee the dynamic query DB Reader DB ConnectionExtractor Table Selection DB Table Selector DB Table Selector DB Reader Data Preparation Extract Table Spec Column Filter DB Table Selector DB ConnectionExtractor DB Reader Select thecolumns you want File Reader Table Columnto Variable DB Table Selector DB Reader DB Query Extractor example demonstrating how to manually enter a selected table and columns - or provide them via a configuation file table_to_select: table_20columns_to_select: "t_20_Cluster_Membership", "t_20_Universe_0_2", "t_20_Universe_1_1" Read existing tables=> select thetable you want(right click and "Execute and Open View")to list alldatabses might vary fromDB to DBLIMIT 10/data/my_database.h2.mv.dbH2 databseextract the column namesColumn Namethe columns fromthe table you selected(right click and "Execute and Open View")configuration_file.txtthe columns fromthe table you selectedsee the dynamic queryDB Reader DB ConnectionExtractor Table Selection DB Table Selector DB Table Selector DB Reader Data Preparation Extract Table Spec Column Filter DB Table Selector DB ConnectionExtractor DB Reader Select thecolumns you want File Reader Table Columnto Variable DB Table Selector DB Reader DB Query Extractor

Nodes

Extensions

Links

Download

To use this workflow in KNIME, download it from the below URL and open it in KNIME:

Download Workflow
Created by: m_lauber
Created at: 2021-09-29
On NodePit since: 2021-09-30
Last update: 2024-04-26
Created with KNIME version: v4.4.1
Tags: h2selectcomponent

Deploy, schedule, execute, and monitor your KNIME workflows locally, in the cloud or on-premises – with our brand new NodePit Runner.

Try NodePit Runner!