Icon

2021_​08_​04_​Values_​to_​Columns_​Data_​Transformation

Values to Columns Data Transformation
Create sample input data Standard trick to replace values in multiple columns Standard trick to replace values in multiple columns Values to Columns Data TransformationThis workflow demonstrates how to transform each value of collection column to multiple columns with Yes/No values.Forum link: https://forum.knime.com/t/transform-each-value-of-a-collection-type-column-to-a-yes-no-column-put-the-value-as-column-name/35094 UngroupPivot for "values to columns" transformationRemove "?" columnAdd column "Yes""values to columns" transformationGroup it with Sum Table Creator Create CollectionColumn Ungroup Pivoting Column Filter ConstantValue Column Unpivoting Rule Engine Pivoting One to Many GroupBy Rule Engine Unpivoting Pivoting Create sample input data Standard trick to replace values in multiple columns Standard trick to replace values in multiple columns Values to Columns Data TransformationThis workflow demonstrates how to transform each value of collection column to multiple columns with Yes/No values.Forum link: https://forum.knime.com/t/transform-each-value-of-a-collection-type-column-to-a-yes-no-column-put-the-value-as-column-name/35094 UngroupPivot for "values to columns" transformationRemove "?" columnAdd column "Yes""values to columns" transformationGroup it with Sum Table Creator Create CollectionColumn Ungroup Pivoting Column Filter ConstantValue Column Unpivoting Rule Engine Pivoting One to Many GroupBy Rule Engine Unpivoting Pivoting

Nodes

Extensions

Links

Download

To use this workflow in KNIME, download it from the below URL and open it in KNIME:

Download Workflow
Created by: Johnny
Created at: 2019-01-03
On NodePit since: 2021-08-05
Last update: 2024-05-01
Created with KNIME version: v4.4.0
Tags: Data ManipulationData TransformationPivotingOne to Many

Deploy, schedule, execute, and monitor your KNIME workflows locally, in the cloud or on-premises – with our brand new NodePit Runner.

Try NodePit Runner!