Transform specific column to binary matrix

BinaryIsPrimary · September 30, 2021, 11:19am

Hello,

I have a table which contains a column ‘country’ with the country name as the value. Now I want to convert this column to a matrix where every country value is a header and the column value is 1/0 depending on a match between column value and header title.

I want to use these columns as input features for a clustering, what’s the best approach here?

Thanks and best regards,
Tim

ipazin · September 30, 2021, 11:28am

Hello @BinaryIsPrimary,

and welcome to KNIME Community! Are you looking One to Many node?

Br,
Ivan

BinaryIsPrimary · September 30, 2021, 11:54am

Hi Ivan,

that’s exactly what I was looking for, thanks a lot!

Best regards,
Tim

system · October 7, 2021, 11:55am

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