Creating Hierarchy

Question

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:

Yoshiro_Fujimori · Answer

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.

Hierarchy.yxmd

Qiu · Answer

@Mattcrowie 
Just as a start

0421-Mattcrowie.yxzp