I am a beginner to knime. So, I didn’t know much, so I signed up here. (I am using a translator in a non-English speaking country. Please understand if the English is awkward)
What I want to ask here is, is it possible to insert a variable in the #table# part of the SQL statement, and how to do it if possible?
If you look at the SQL Statement menu in the Database Reader Configuration, it says’Select * from #table#’. I know that if the table name in DB is put in #table#, the selected data goes up in memory.
I want to automatically insert the data read from another Database Reader into #table# without entering it directly in the #table# part.
For example, I want to use Table_name read from All_tables of Oracle as a variable and insert it into #table# part of SQL Statement of Database Reader.