Results 1 to 12 of 12

Merging bill of materials (power query?)

Threaded View

  1. #1
    Registered User
    Join Date
    06-24-2023
    Location
    Netherlands
    MS-Off Ver
    MS 365
    Posts
    10

    Merging bill of materials (power query?)

    Hello everyone,

    I have been trying to create a program in PowerQuery where i can merge 2 bill of materials based on the equal sub assy descriptions. I have came a long way but could not be able to merge these when the level depthness is more than 1.

    I have inserted an example in the appendix of 2 seperate bill of materials and the desired merged bill of material.

    Some rules are:

    - Bill of material 1 is the main structure, where the bill of material 2 subassy's should be added when there is a match in description (yellow and orange colours).
    - The leveling needs to be correct. Should probably at some point be recalculated.
    - The green subassy does not have a match so should remain the same.
    - The prefered tool to solve this is PowerQuery, however feel free to advice something else

    Is this even possible?

    Thanks in advance!
    Attached Files Attached Files
    Last edited by fvdw; 03-21-2024 at 06:19 AM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Bill of Materials / Macro VBA
    By mervecevik in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-28-2018, 08:03 AM
  2. Bill of Materials
    By DennisWA in forum Excel General
    Replies: 7
    Last Post: 11-27-2017, 06:05 PM
  3. Condensing Bill of Materials
    By AndyStanton in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 03-23-2016, 12:11 PM
  4. BOM (Bill of Materials) Explosion
    By AndySimm2000 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-18-2016, 06:06 AM
  5. Help with Designing a Bill of Materials!
    By blakewalker in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-22-2012, 11:52 AM
  6. Bill of Materials
    By tonyhindmarsh in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 11-19-2007, 05:37 AM
  7. bill of materials
    By stevekirk in forum Excel General
    Replies: 7
    Last Post: 12-10-2006, 05:12 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1