1 Column Hierarchy Breakout

Split a one column hierarchy out to a parent child column map based on a delimitator. This automatically handles both indent based hiearchy structures with a single entry per line, or full address hierarchy structures with parent and child relationships broken out by a charater patterns. It also allows for a sub-breakout for cases like account numbers and account names included in each hierarchy level.

Options

Remove Hierarchy Mapping Columns Before Sub Breakout?
Enter Description
Hierarchy Column for Breakout
Enter Description
Secondary Split on Hierarchy Map (ie: Acct # / Name) ***Settings Below Only Active if Yes***
Enter Description
New Hierarchy Breakout Column Labels?
Enter Description
Value basis for string column split?
Enter Description
Value basis for secondary string column split?
Enter Description
1st Sub Breakout Column Label
Enter Description
2nd Sub Breakout Column Label
Enter Description

Input Ports

Icon
No description for this port available.

Output Ports

Icon
No description for this port available.

Nodes

Extensions

Links

Download

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

Download Component
On NodePit since: 2023-04-28
Last update: 2024-04-28
Created with KNIME version: v4.7.2

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

Try NodePit Runner!