Add New Column (Expressions, Date time)

[ipazin]

Hello @kotvir,

and welcome to KNIME Community!

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:

Making a DateTime field in a database automatic?

Additionally have a look at this topic where KNIME ETL capabilities are discussed:

Knime Use Cases

Hi everyone, I am trying to understand what are the main use cases for Knime. What problems does it help solving? What it can do that other tools can’t. Are there alternatives? The reason I am asking - I was asked to evaluate if my company needs Knime (someone from leadership have heard of the tool in the conference). Hence I am here collecting facts. So far, after little research, my understanding is as follows. Knime is: Business users / non-developer friendly ETL tool: Alternatives would …

Br,
Ivan