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:
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.
