Data Tranforamtion

[SomuGS]

Hi,

I'm looking to transform columnar data into matrix form and assign ID (like catalogue ID)

Any help would be appreciated.

Thank you!

[flying008]

Wow ! like a BOM form !

[Yoshiro_Fujimori · Accepted solution]

Hi @SomuGS ,

I have two approaches.

One is to use Network Analysis tool, but it turned out to be not effective in this case.

Network Analysis Tool

Output

Another is to use Join tool multiple times until you do not find any child node.

Join Tool

(I guess your data is wrongly connected at the row below, and corrected it to Level 7.)

Output

As I am not sure the sorting order, I just sorted at each level.

I hope this is of some help.

[SomuGS]

Konichiwa Fujimori Yashiro sama!

Thanks for looking this and your second solution was of great help. And with regarding to your observation on incorrect data connection "Item T" is at level 7 with two inputs.

Also, I wanted to sort the final results in ascending order at each level.

Arigato gozaimasu!

Bharat S