Icon

Bill of Materials (BOM) with recursive loop demonstration

<p>Processing a "Bill of Materials" (BOM) structure with a recursive loop.</p><p></p><p>The Bill of Materials structure identifies a set of products where a given product may be comprised of a set of other products.</p><p></p><p>Open the "Choose Item and Quantity" View (select that component and press F10), and select an item and a quantity.</p><p></p><p>The recursive loop will then process the product hierarchy to produce the "bill of materials" required for building that quantity of the chosen item.</p><p></p><p>@takbb Brian Bates 3 November 2024</p>

Processing a "Bill of Materials" (BOM) structure with a recursive loop.

The Bill of Materials structure identifies a set of products where a given product may be comprised of a set of other products.

Open the "Choose Item and Quantity" View (select that component and press F10), and select an item and a quantity.

The recursive loop will then process the product hierarchy to produce the "bill of materials" required for building that quantity of the chosen item.

@takbb Brian Bates 3 November 2024

Create Sample Data - BOM Structure and Parts List

The current "Parts" is collected on each iteration, and the components for these parts are then passed to the next iteration.

Processing terminates when there are no further components to process

Choose ITEM and QUANTITY



The full list of partsand their componentsEdit this to make your ownparts/components structure
Table Creator
Column Filter
Column Filter
Column Renamer (Reference)
Concatenate
Master Parts List
CSV Reader
find all components for all the partsand the required quantities
Joiner
get product description for eachcomponent part
Value Lookup
return part id and part descriptionfor next iteration
Column Filter
"requested product"
Column Renamer
Column Resorter
Column Filter
Multiply required productby the quantity
One Row to Many
PARTS LIST
Duplicate Row Filter
Master Parts List
CSV Reader
get required column list order
Extract Table Spec
Parts List
CSV Writer
remove quantity column aswe are returning a rowfor every individual item required
Column Filter
BOM Structore
CSV Writer
add this product codeto hierarchyto keep breadcrumb trailfor each product
String Manipulation
BOM Structure
CSV Reader
ensure columns are in correctorder for next iteration
Reference Column Resorter
input port 1 collected Bill of Materialsinput port 2 - items to process on next iteration
Recursive Loop End
input: parts to be built
Recursive Loop Start
Open viiew (F10) toselect required item and specify the quantity
Choose Item and Quantity

Nodes

Extensions

Links