Creating an Diagramm from a Excel Treestructure

Question

Hello together,

i am trying to create an diagram from an product structure that i have in an excel file.

The structure of the data is like these

Ldf. Nummer	ArtikelNr	Label
1	110	A1
1.1	111	A2
1.1.1	112	A3
1.1.1.1	113	A4
1.1.1.1.1	114	A5
1.1.1.1.1.1	115	A6
1.1.1.1.1.1.1	116	A7
1.1.1.1.1.1.1.1	117	A8
1.1.1.1.1.1.1.1.1	118	A9
1.1.1.1.1.1.1.1.2	119	A10
1.1.1.1.1.1.1.1.2.1	120	A11
1.1.1.1.1.1.1.1.2.1.1	121	A12
1.1.1.1.1.1.1.1.2.2	122	A13
1.1.1.1.1.1.1.1.2.3	123	A14
1.1.1.1.1.1.1.1.2.4	124	A15
1.1.1.1.1.1.1.1.2.5	125	A16
1.1.1.1.1.1.1.1.2.6	126	A17
1.1.1.1.1.1.1.1.2.7	127	A18
1.1.1.1.1.1.1.1.3	128	A19
1.1.1.1.1.1.1.1.3.1	129	A20
1.1.1.1.1.1.1.1.3.2	130	A21
1.1.1.1.1.1.1.1.3.3	131	A22
1.1.1.1.1.1.1.1.3.4	132	A23
1.1.1.1.1.1.1.1.3.5	133	A24

Would it be possible to create automaticly an diagram from these data (excel file)? Like an hierarchic structure? I have not get it until now :-( So i have no seperate colum with start and target identifier.

If i try to create it its shows me no edges. Is it possible for yed to proceed datas in these form, or must i change it like "from to"?. Can anyone help me?

Many thanks

 

Pascal

Answer 1

What kind of structure are you expecting from the given data? E.g. suppose you have nodes representing lines

1.1.1.1.1.1.1.1	117	A8
1.1.1.1.1.1.1.1.1	118	A9
1.1.1.1.1.1.1.1.2	119	A10

Should those be chained one after the other because of the subsequent ArtikelNr (i.e. A8 -> A9 -> A10) or should A8 get connected to both A9 and A10 due to Ldf. Nummer for A8 being the prefix for Ldf. Nummer for A9 and A10?

In any case you need to tell yEd the desired structure of the generated diagram. Hence you need to add an additional column that you can use to designate target IDs.