Icon

2020_​03_​12_​Replace_​Values_​over_​Multiple_​Columns

Replace Values over Multiple Columns
Replace Values over Multiple ColumnsThis workflow demonstrates how to perform value replacement in multiple columns without using Column List LoopStart node but rather utilizing Unpivoting node to have all columns that need value replacement in one column. To obtainoriginal table structure after replacement is done Pivoting is used.Forum link: https://forum.knime.com/t/replace-yes-by-1-and-no-by-0-multiples-columns-in-knime/21714 Input dataGet all columns that need replacement into one columnAdd replacement logicyes = 1no = 0Get back with original columnsDrop RowID column Table Creator Unpivoting Rule Engine Pivoting Column Filter Replace Values over Multiple ColumnsThis workflow demonstrates how to perform value replacement in multiple columns without using Column List LoopStart node but rather utilizing Unpivoting node to have all columns that need value replacement in one column. To obtainoriginal table structure after replacement is done Pivoting is used.Forum link: https://forum.knime.com/t/replace-yes-by-1-and-no-by-0-multiples-columns-in-knime/21714 Input dataGet all columns that need replacement into one columnAdd replacement logicyes = 1no = 0Get back with original columnsDrop RowID column Table Creator Unpivoting Rule Engine Pivoting Column Filter

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: 2020-03-12
Last update: 2024-05-03
Created with KNIME version: v4.1.2
Tags: Data ManipulationLooplessUnpivotingPivoting

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

Try NodePit Runner!