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?
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
Correction. Dates are in DDMMMYYYY.
The month is 3 letters, all caps. e.g., 02JAN2021
To convert to KNIME format you can also try
node
1 Like
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.