Changing column datatype after Pivoting process


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?

Thank you.


Hi @bonamana90, have you tried the Column Auto Type Cast node?


Thank you very much for this solution :grinning:

1 Like

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.