Dear reader,
I want to create a Network chart, however I have some a different data structure than usual, here is an example (it is a splitting process, not combining):
ID | Material | output | input |
1 | cookie | | 1 |
1 | chocolate | 1 | |
1 | dough | 1 | |
2 | pineapple | | 1 |
2 | peel | 1 | |
2 | middle | 1 | |
3 | cookie | | 1 |
3 | chocolate | 1 | |
3 | dough | 1 | |
3 | almonds | 1 | |
4 | cookie package | | 1 |
4 | cookie | 1 | |
4 | packaging | 1 | |
I want to see materials as nodes, and the connection between the materials. In example, from 'cookie package' you can go all the way to 'dough'. On the line I would like to see the ID number.
I hope you can help me out achieving this, if you need additional information I am happy to provide that!