Creating network chart from database with implicit link of data

[Mattie]

Dear reader,

I want to create a Network chart, however I have an implicit relation in the data. 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'.

I hope you can help me out achieving this. If you need additional information I am happy to provide that!

[Mattie]

Dear reader,

I want to create a Network chart, however I have an implicit relation in the data. 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'.

I hope you can help me out achieving this. If you need additional information I am happy to provide that!