Creating Hierarchy
Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
Mattcrowie
5 - Atom
‎04-20-2023
09:34 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi!
I am attempting to create a hierarchy with my dataset as follows:
Each part number is assigned certain subparts (2, 2.1, 2.2 etc.). One part number could be assigned 3 different subparts for example.
Input so far is as follows:
I have managed to get the subparts in order but I am struggling to separate the subparts into different columns mimicking the hierarchy shown below. Expected output:
Labels:
- Labels:
- Workflow
2 REPLIES 2
21 - Polaris
‎04-20-2023
09:41 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@Mattcrowie
Just as a start
15 - Aurora
‎04-20-2023
10:15 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi @Mattcrowie ,
Another way of doing this.
Assuming the part number is separated with period('.'), you can get the level to use it as separate columns later.
Input
Workflow
Output
I hope this may be of some help. Good luck.
