Is there a way to export a BOM/List of every Product and Part in a Catia Product?
I would like a full list of everything, not broken down by each Product.
Step 2: Filter your relevant column by the term "Recapitulation". This should give you only one row.
Step 3: RMB on that number in the index column and select "drill down" This will output that number as a value and you can use it in the next step.
Step 4: Duplicate the query and delete some steps. Finally you can filter top rows. Please see the formula bar and how to use the number from step 3. You need "+4" because you also have to filter some 4 preset rows where Catia writes some stuff.
Thanks for all the help this has worked great with my limited excel abilities.
I have a few questions:
1. Does the "query_index" need to be changed to the format that shows a 123 the the left of the title?
I was able to get all of this done and it seemed to perform correctly, but my "query_index" shows up just like the "query_parts" in your picture as a sheet.
2. My product has multiple of the same assemblies, is there an easy way to combine duplicate rows and have it add the Quantity column together?
3. What is the best way to implement this for future uses?
Can I set this multi-query / combination up as a Macro to run on the exported BOM when I open it in Excel?