I am still quite new to Knime and currently I have a dataset that requires pivoting process. The target column to be treated as Pivot has a datatype of Nominal. My intention is to convert all columns that were changed to columns as a result of Pivoting into other types such as String, Integer and Double.
This is an example of the dataset Before pivoting:
Image below is after pivoting:
I have tried using String Manipulation node and yes it does work. However, how do I go about with over 100 pivot columns? Because using over 100 String Manipulation nodes is kind of a hassle. Any other nodes that would help my current situation?