Solution to an exercise for data and time manipulation.
Transform date and time values from string to the dedicated Date&Time format. Remove redundant digits from the timestamps. Extract the day of the week from the dates, and aggregate the data.
CHECK YOUR ANSWERS:
1. The highest number (9382) of last reviews were given on Sunday
2. The lowest number (3554) of last reviews were given on Thursday
Workflow
01 Date and Time Manipulation - Solution
External resources
Used extensions & nodes
Created with KNIME Analytics Platform version 4.4.0
Legal
By using or downloading the workflow, you agree to our terms and conditions.