Exploding Intermediates into Raw Materials

[amrzahran12]

Hello everyone,

I would really appreciate any help with the following as I have been struggling with this for few days with no success.

My dataset represents the bill of materials used to produce finished products. Every finished product is composed of intermediates and raw materials. All intermediates are also composed of raw materials.

I want to create a workflow that will list the bill of materials of every finished product by exploding the intermediates into raw materials.

Sample Input

Column 1	Column 2	Column 3	Column 4	E	F
Product	Type	Component	Description	Type	BOM Quantity
A	Finished Product Part	B	Material-B	HALB	1
A	Finished Product Part	C	Material-C	HALB	2
A	Finished Product Part	D	Material-D	ROH	3
A	Finished Product Part	E	Material-E	ROH	3
A	Finished Product Part	F	Material-F	ROH	4
B	Intemediate	C	Material-C	HALB	5
B	Intemediate	K	Material-K	ROH	6
C	Intemediate	L	Material-L	ROH	1
C	Intemediate	M	Material-M	ROH	1

Sample Output

Column 1	Column 2	Column 3	Column 4	E	F
Product	Type	Component	Description	Type	BOM Quantity
A	Finished Product Part	D	Material-D	ROH	3
A	Finished Product Part	E	Material-E	ROH	3
A	Finished Product Part	F	Material-F	ROH	4
A	Finished Product Part	K	Material-K	ROH	6
A	Finished Product Part	L	Material-L	ROH	7
A	Finished Product Part	M	Material-M	ROH	7
[Sample Input-Output.xlsx	attachment](upload://pDhQEaLfYsKCyWHxuNiVt81v9Rk.xlsx) (13.5 KB)

Thanks a lot

[rfeigel]

You didn’t upload the data file. Use the upload icon and point it to the file.

You need to provide more detail about how the input translates to the desired output. What’s the difference between “Finished Product Part” and “Intermediate”? Your example output seems have components and materials that don’t relate to the input.

[amrzahran12]

Sample Input-Output.xlsx (13.5 KB)

[amrzahran12]

I just uploaded the Excel, sorry seems I made a mistake before.

Finished products are the final complete product which is composed of a mixture of intermediate products and raw materials. Those intermediate products are themselves made up of raw materials. The excel file has a visual representation of the bill of materials.

Thank you

[takbb]

Hi @amrzahran12 , I just saw your post after responding to another post about BOM structures.

I wonder if the example I have supplied here may be of use to you too

Iterating over a multi-level Bill of Material

@rkehrli , I have uploaded a demonstration of a method of processing a BOM structure using a recursive loop. You will see at the top of this flow is an annotated set of nodes for creating the BOM structure and product list which are included in the flow. You can edit the Table Creator to modify the hierarchy if you wish to experiment, and then re-execute the upper flow to build the new csv files which will then be used in the lower flow. In the lower flow, select the “Choose Item and Quantit…