Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

Creating Hierarchy

Mattcrowie
5 - Atom

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:

Hierarchy.jpg

 

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:

 

Output.jpg

2 REPLIES 2
Qiu
21 - Polaris
21 - Polaris

@Mattcrowie 
Just as a start

0421-Mattcrowie.PNG

Yoshiro_Fujimori
15 - Aurora
15 - Aurora

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

Yoshiro_Fujimori_0-1682053662215.png

 

Workflow

Yoshiro_Fujimori_3-1682053894595.png

 

 

Output

Yoshiro_Fujimori_4-1682053972335.png

 

I hope this may be of some help. Good luck.

Labels
Top Solution Authors