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