All,
KNIME is a wonderful tool and I am making very good progress on my task. My congratulations to the folks who designed and built this!
I have what I hope is a simple question. Using the Database Writer node, I am attempting to output my data into a table in my database. The output works, but the column names are renamed in a way that will confuse joins at a later date, since these same columns were previously read from the same database. In particular, a table with the column name "This & That" (including the quotation marks) inside KNIME shows up in the database as _This___That_ (with no quotation marks or ampersand, but with five underscore characters).
Generally I do not know ahead of time what these column names will be, so renaming them by hand (for instance, to add more quotes or backslashes or some other escape character) is not really possible. Is there a way I can output the column names with their quotation marks?
Many thanks,
Bill N