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

mlauber71 January 9, 2025, 10:46pm 5

@Heinz using code there is also this solution

1 Like