Forum Discussion

vonckk's avatar
vonckk
Frequent Visitor
5 years ago

Tips to avoid multiple merge steps in 1 query

 Hey All,

 

I'm hoping to solicit some tips and/or advice.  I have a query where I'm taking a piece of data, which is really a low-level hierarchy number.  From that, I'm breaking it out into it's component parts (higher levels in the hierarchy) and for each level that I break out, I'm grabbing a description from a second table.  Unfortunately, the only way I know how to do this is through merging the same two tables multiple times in the same query.  It is extremely draining and takes forever to update.  

 

First set of steps (breaking out component parts of the hierarchy)

 

 

Second set of steps (many, many merges)

 

 

 

Does anyone know of a different way to approach this problem?  I'd love to only merge the data one time, if possible?

 

Link Below:

 

https://rocketsutoledo-my.sharepoint.com/:x:/g/personal/kvonck_rockets_utoledo_edu/EfPiQxyOIh9PgH_Zu4guueQBMMDkLet2JKLDzO5989Z7qw?e=0zCxek

 

 

Need Help
Tips and Tricks

3 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Hi vonckk 

     

    You need to provide some sample date in a format that everyone can copy, and expected results. You can use dummy data, it's too difficult to imagine what you are doing without enough context.

    • vonckk's avatar
      vonckk
      Frequent Visitor
      5 years ago

      Thanks Anonymous  I'm attaching an excel file with the Power Query's in question.  I'm most concered with the [WBS Standard] query.

       

      Thanks!

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Hi vonckk 

     

    I guess you put it in your one drive, and it does not allow people outside your organization to access directly...I will pm you my email, then you can send your sample data