Clean strings
So far you have removed columns and rows from the employees table, converted the type of some of the columns and handled missing values. However, you cannot throw everything away! There are some nodes to fix and manipulate the table entries. In this case, the data has inconsistent formatting and contains unnecessary white spaces in some of the columns. Clean it with the String Cleaner node.
If you lost any progress, browse your Local space
, click on the introduction-to-knime
folder, and load the 3_2_missing_values
workflow from the Exercises
folder.
This exercise is part of the course
Introduction to KNIME
Hands-on interactive exercise
Turn theory into action with one of our interactive exercises
