BOM Mass split-up

[karram]

Using I-Logic how to split and Extract the weight from inventor BOM and paste into Excel.

For Example: Item: 1K contains Item 2,3,4 and Item 5K contains Item 6,7,4.

Now in Excel i need Weight for Item 2,3 and 4 split into 7 Qty weight only paste under item 1K. ( 415,4+593,5+592,5+29,4) Totally 1630,8kg

In the same way  under item 5K (414,1+560,5+560,5+33,7) Totally 1568,8kg.

How can i Extract Weight from BOM in inventor to Excel format like below case.

In BOM i feed K-part attachment without any space like (1K7,5K8) like that. 

[Andrii_Humeniuk · Accepted solution]

Hi @karram . How do you create an Excel table like the one in the screenshot? If you are using some code then you will need to share it so that your requests can be added.

[Andrii_Humeniuk · Accepted solution]

Hi @karram . Considering the confidentiality of information, I hope my private solution was useful for you. Thank you.