BOM - Row Merge Settings

[rcoi]

Hello everyone, due to the structure of my assembly and since I use it in different drawings, I need to merge the rows by another parameter , I  need to merge by "Stock Number" too.  Is there a code to make this work?

Context: I find myself exporting the BOM "Only Parts" to Excel. Its working very well but need to merge some rows.

Tank you!

[A.Acheson]

First question I would ask on this, is can you do this operation in the manual workflow and by doing so will it affect other drawings/ drawings you have worked on? 

I am assuming your working exclusively with the Assembly BOM and if so maybe this merge setting will help. 

Syntax

BOM.SetPartNumberMergeSettings( MergeEnabled As Boolean, [MergeKeys] As Variant )

If your not using the merge setting manually then this may need to be done in excel after the export. Can you supply an image of the before and after BOM merge? 

[rcoi]

Hi alan, thank for your reply. This does not affect my drawings since I do not use the "only parts" BOM, only to export it to Excel. I send you an image of my BOM and the elements that I want to group with respect to the "Stock Number" property.

The question is: Can I group it using Inventor or should I do it in Excel after exporting?

[A.Acheson · Accepted solution]

I don't see a merge under different iproperty option in the manual workflow so it won't exist in the API method. 

Maybe group by stock number in the partslist would be the functionality you want then export to excel?