I am new to Knime. I have a table with some data from vehicle diagnostics.
In this table, I intend to add columns equal to the number of values in ECU_FC column with every value as header of newly created columns. I have done this in IBM SPSS using SetToFlag node. The desired output from SPSS is as shown below.
In this table every entry in ECU_FC is transformed to a new column. And a flag is set for these values (1 for true value and 0 for false).
I wish to do a similar operation in Knime. So I came across the node One To Many. The input to this node is the data table shown above. In the settings, I select the column ECU_FC in the Include option. When I try to apply these settings I get an error as 'column: ECU_FC has no possible values'.
I also tried to add the Domain Calculator node before the One to Many node but no success.
It is a relatively simple operation, but I seem to be missing something here. I would be very thankful if I could get any help regarding this. Thank you.