Duplicate Column Selection

Hi all - My workflow generates new columns outputs after executing (named External Record ID, Record External Source) and they get written to the Excel file. The issue I’m facing is if I execute the new Excel file (with the new columns) again I want those to be overwritten with the new values in each of those columns, however, since Knime recognizes those columns as existing already, it duplicates them iteratively (#1, #2, etc. gets appended if there are duplicates). How would I select the new versions of the columns while still maintaining the option if this is the first time the workflow is being run where the columns don’t exist, but still have logic to handle when they already do.

@mvaldes you could try one of these options. A suggestion by @Iris to use a Table Validator

Or there is this switch based on a Java snippet

And then you might just create an empty column of that name in the first place.

2 Likes

@ahmadhakim welcome to the KNIME forum.

You included a link to a commercial website that has no obvious connection to the topic discussed. You might want to consider if this is helping the conversation - also with regards to the FAQ:

https://forum.knime.com/faq