I hope you are doing well!
I am trying to find out a way to automatically group skills into a broader group. For example, I have a database where students input their skills. This is free text and there is no way to change the collection method or system. Due to this, I get many related things. For example, one student can put “data visualization” but another can put “data chart visualizations” and another can put “statistics visualization” and another “data charts”. Is there a way in which Knime nodes can just automatically make all these skills name be change into “Data Visualization” for example? But have Knime decide this category automatically?
Thanks for wanting to help me with this. I can share the below image. As you will see, there are different but related skills. The objective is to bucket such related skills into a broader category that captures their central commonality automatically, without having to create a data dictionary manually. For example, everything cointaining “Python” will fall under an automatically category created called “Python”, everything containing “QA” will fall under the automatically created category called “QA”
