SQL code in the DB Table Selector

Hi all,

Currently i am using DB Table Selector SQL code to filter & search for data A and display in Box plot for data A. Afterwards, i created another DB Table Selector SQL Code to filter and search for data B and repeated similar for display. May i know what is the DB Table Selector SQL code i should type in order to search for data A and follow by B and display both data in the same box plot rather than seperately. I have > 10 parameters would like to combine all under same box plot.

Hi @waikok13,
Welcome to the KNIME Forum! You can use both DB Table Selectors in parallel without any custom SQL code and then use the new DB Concatenate to create a UNION of both results. Then read the result with a DB Reader. If you want to do it in SQL, it should be something like

SELECT * FROM A UNION ALL SELECT * FROM B

Kind regards,
Alexander

1 Like

This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.