Forum Discussion

ema_rz's avatar
ema_rz
Copper Contributor
May 20, 2022
Solved

Search of multiple values connecting multiple tables

Hello everyone. I have an issue with managing multiple tables. I’m not practical with Power Query or VBA, so I hope some of you can give me a hand to solve this. I have 6 tables. The goal is to ret...
BI & Data Analysis
excel
Formulas and Functions
Macros and VBA
office 365
  • Riny_van_Eekelen's avatar
    Riny_van_Eekelen
    May 26, 2022

    ema_rz Now, I didn't recreate your tables, 6 levels deep, but did a mock-up at a smaller scale in Power Query. Although you mentioned not to be "practical" with PQ, you might be able to follow the steps in the attached (not so elegant) example. With a number of consecutive merge and expand steps, starting with the last table, you will end up with the sequence of items from the first column in the first table that correspond to the item selected from the second column of the last table.

     

ema_rz's avatar
ema_rz
Copper Contributor
May 26, 2022

HansVogelaar Unfortunately it doesn't work properly.

Riny_van_Eekelen's avatar
Riny_van_Eekelen
Platinum Contributor
May 26, 2022

ema_rz Now, I didn't recreate your tables, 6 levels deep, but did a mock-up at a smaller scale in Power Query. Although you mentioned not to be "practical" with PQ, you might be able to follow the steps in the attached (not so elegant) example. With a number of consecutive merge and expand steps, starting with the last table, you will end up with the sequence of items from the first column in the first table that correspond to the item selected from the second column of the last table.

 

Resources