I have a condition, where I need to create a new column “date” that is filled automatically (according to the current date). For example, I have a Status column with the value “Done” then I create new column with the current date. Is there a solution for this?
Thanks for your attention. sorry I missed something, the number of rows of my data is dynamic (>1000 rows). I need to be able to create a condition if the status is “match”, then create a new column “date” with value “current date”, otherwise it will be null. I tried some experiments and finally used a node Python script, and the result is the case has been resolved.
Glad you solved your problem. I don’t know exactly how your input is configured. Based on your original post I made a guess. Here’s a workflow that uses only native KNIME nodes (no Python). Auto Create Current Date Based on Status.knwf (101.2 KB)