Group by, begins with dates

KNIME Analytics Platform
#1

My dates are in the format YYYYMMDD. I’d like to group counts by months and year. If I was in Excel I’d create new columns with year and month. What’s the best way to do this?

#2

Hi @ayscueb -

You can use the String to Date&Time node to convert to a native KNIME date, and then afterward use the Extract Date&Time Fields to get the year and month fields desired.

Something like this:

2 Likes
#3

Correction. Dates are in DDMMMYYYY.

The month is 3 letters, all caps. e.g., 02JAN2021

#4

To convert to KNIME format you can also try

node

1 Like
#5

In that case you will need to convert to mixed case (e.g. “Jan”) for the months in order for the String to Date&Time node to parse it properly.