i have to create an empty table with column names and defined data types. I don’t want to do this manually. I would like to use an extra specification table. So I need the opposite of the node: Extract table Spec Create Table by Spec…
Is that possible, can anybody help me?
Of course you could just create a KNIME tase from scratch and define the types of the columns - or if you have an existing file you could just use that and remove all lines with data …
And then you might create a Table in a SQL database like H2 from code and then bring that to KNIME. If you are into coding.
i create the table “by hand”…
The other options are not working in my cases…
Not sure I do follow. If you have an existing table within KNIME (wherever that came from, maybe from importing an Excel file). Would it not be possible so simply remove all lines and just use that as an empty table?
If you want to define the types by some sort of meta file I would have to think about some sort of loop to simulate the creation of a table by hand. But I am not sure if this is worth the effort.
Maybe you could tell us more about what you want to do.
of course it possible to create and load some data and remove all the lines. But I don’t want to this. I want to create the table in a workflow comparable to the first initialization of a table in a database. Anyway i thought that i overlooked something because there is a “extract table spec” node but no “create table by spec” node.
But i agree with you it’s not worth the effort to create some sort of loop to simulate the creation of a table by hand.
This topic was automatically closed 182 days after the last reply. New replies are no longer allowed.