Changing column datatype after Pivoting process

KNIME Analytics Platform
1

Hello,

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

Image below is after pivoting:

image

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.

Izzat

2

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

2 Likes
3

Thank you very much for this solution :grinning:

1 Like
4

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