Combining variables to 1 date

Hello so I have a dataset that that has the variables year, month, day, hour. I was able to combine the year, month, and day to extract the day of the week but how do I combine it with the hour and extract the hour of the day

Hi @FiidisksDiduui,

Can you please provide some examples?

:blush:

1 Like

image
Yea so this is an example of the new variable created while combining year month day.
image
And using the extract ate&time field node I can get the day of the week. Is there a way I can extra the field, hour of day?

I cannot see the time in your example. Do you have any time fields?

2 Likes

Hi @FiidisksDiduui,

if you already have an hour as a column why do you want to add it to your Date and extract it again? Anyways you can use join() function from String Manipulation node to join date with hour. This will give you new string column which you can convert using String to Date&Time node to be able to use Extract Date&Time Fields node.

Br,
Ivan

1 Like