(Week Number, Year) to DD/MM/YYYY

Hi there @amrzahran,

you can use Create Date&Time Range node with configuration like this:

There are two things to configure in Create Date&Time Range node:

  • starting point - the date you want to be the 1st day in week
  • number of rows - that would be the number of rows in your input data

The latter you can do dynamically (if there is need for it) in a way that you extract number of rows from input table into a flow variable and use it Create Date&Time Range.

This will create a Local Date column type and considering there is a Tableau integration within KNIME maybe this is enough for Tableau and you don’t need DD/MM/YYYY format. Unless it is not check this topic how to change format type.

Br,
Ivan

3 Likes