Forum Discussion

edwardroa's avatar
edwardroa
Icon for Helper I rankHelper I
3 years ago

Combining 3 tables in Power Query without losing any columns

Firstly thank you for looking into my query!

 

I'm struggling to combine 3 tables into 1 tables without losing any columns. I am currently using the "Append Queries" function to combine the 3 tables into the 1 table however when I combine them, instead of using a unique column and adding additional columns onto the end, it loads the 3 tables as 3 separate lines.

 

For example, below are 3 tables with one column in common across the 3 tables (Unique reference):

 

Table 1

 

Table 2

 

Table 3

 

Desired Table

 

I'm sure there must be an easy way however I've not been able to find it yet.

 

Any guidance would be much appreciated.


Thank you,

Edward

Need Help

2 Replies

  • Adel's avatar
    Adel
    Icon for Helper III rankHelper III
    3 years ago

    you could use this for example 

    You can use List.Generate() to try your loop query and then append the list like:

    let
...
TablesToAppend = List.Generate(your loop query),
TablesAppended = Table.Combine(List.Transform(TablesToAppend, each (_))),
...
in
...
    • edwardroa's avatar
      edwardroa
      Icon for Helper I rankHelper I
      3 years ago

      Hi Adel,

       

      What do you mean by "your loop query" please?

       

      Kind regards,

      Edward