To add a column with the timestamp you can use the Create Date&Time Range node.
For Expresions there are nodes like “Column Expressions” and “Math formula”.
Hi, I did create date range, but it’s creating for one row. As I mentioned I need for each row as a derrived column. For each row being generated from source, I need a column like Load_Date as current date time.
I do not know if is the best solution but you have to use a loop for every row, do the calculations and then register the time of execution and append a column. In my example the “Wait” node is just for simulate the execution of the workflow.
It’s not possible to create/have such load timestamp for each row in DB table from within KNIME. Best you can do is what @andrejz suggested - same timestamp for all records. To have load timestamp you have to create such column(s) in database:
Additionally have a look at this topic where KNIME ETL capabilities are discussed: