Dear all, I have to check a table if a column exists. If yes (column is already existing): column values should be set to null if no(column is not existing): column should be added. in pseudo code: if exists (column"test") then all column(“test”)=null else add column(test) In forum I found an node if column exists from column, but I can’t find it. Is there a smart way to realize? Thanks for help! BR, Heinz

I think (hope!) it was resolved here… :wink: [image] If column exists node not available KNIME Analytics Platform Thank you very much for detailed explanation. Please find below my comment: I terminated (exit) temporary ZScaler that was running on my machine (maybe you have to contact your IT Admin to be allowed to do this). After this was done, there was no problem to insert the requested component into my workflow by using drag and drop. Then I activated ZScaler again. BR, Heinz

if column exists

KNIME Analytics Platform

takbb January 9, 2025, 6:38pm 4

Yes, internally my above component does uses “extract table spec”.

There is also this clever alternative demo workflow from @s.roughley which uses the Vernalis nodes to solve this problem, so that’s another option too

It featured on the following forum thread

4 Likes