Icon

Combine Three Consecutive Columns

This workflow shows how to solve the following problem:

If I have in different columns A, C, D, E, F, G, H, I… and I want to fuse regularly every 3 characters in a single string each in a single column like ACD, EFG, HI

This workflow shows how to solve the following problem:If I have in different columns A, C, D, E, F, G, H, I… and I want to fuse regularly every 3 characters in asingle string each in a single column like ACD, EFG, HI Create ExampleDataCombine all Columns intoone CellAdd a Delimeterafter 3 CharactersSplitt basedon the Delimeter Table Creator Column Combiner String Replacer Cell Splitter This workflow shows how to solve the following problem:If I have in different columns A, C, D, E, F, G, H, I… and I want to fuse regularly every 3 characters in asingle string each in a single column like ACD, EFG, HI Create ExampleDataCombine all Columns intoone CellAdd a Delimeterafter 3 CharactersSplitt basedon the Delimeter Table Creator Column Combiner String Replacer Cell Splitter

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: mw
Created at: 2019-10-31
On NodePit since: 2021-06-25
Last update: 2024-04-30
Created with KNIME version: v4.3.3

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

Try NodePit Runner!