Auto create current date

Hello, greetings to all colleagues.

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?

Thank you for your attention and help

Eno.

Use the Create Date&Time Range node. Set the # rows as required.


date table

3 Likes

hello @rfeigel

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.

Thank you.

Eno.

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)

4 Likes

Hello @rfeigel

thank you for giving that example, because that’s the flow I was hoping for. Thank you very much for your help and attention. God bless you.

Thank you.

Eno.

1 Like

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.