Flattened BOM to Multi-level BOM

1

Hi Community,

I have a use case to convert Flattened BOM to Multi-level BOM.
Here are two background information:
PLM, product structure and multi-level BOM. Let’s sort it out…
[BOM Types]
(https://help.openbom.com/get-started/bom-types/)

Requirement:
From Input - Flattened BOM, generate an Output - Multi-level BOM.
See attached snapshots.
image
image
image

I could almost there in EasyMorph. The problem is, I could not make the item name to show in the output area. I could make them if I modify them with Excel VBA codes.

Just wondering how I could make them in EasyMorph?

image
image1625×480 62.4 KB

Thanks for your help in advance.
Br. Cambridge

2

Hi,

Should work like this. I guess you only have to change the behaviour of the Pivot action.

image
image1093×364 20.5 KB

MultiLevelBOM.morph (3.5 KB)
MultiLevelBOM.xlsx (10.1 KB)

Regards,

Jochen

3

Many thanks Jochen!
Now I learn this “Any” value in Pivot table, brilliant!

1 Like
4

Hi Cambridge,

Just be aware that your input BOM is not flattened but recursive.
A flattened one would directly link top level to lower levels : the left column would only contain “item number 1”.
I suggest you could have a look to the “Repeat” transformation, this will help you to handle all the tree structures.

Regards

5

Thank you cvo. I got your great input.

Br. Cambridge