Append vs Merge using Power Query

[Josh_BI_UK]

Original question posted by @actzikas within a wrong thread. This post aims to answer actzikas question:

"Could you bring into two tables as a source? 
= Table.SelectColumns(Table 1, {"OwnerId", "Type", "CreatedDate", "Creator_Role__c"}) 
and somehow have another Table.SelectColumns for Table 2" link to original post  

[Josh_BI_UK · Accepted solution]

Hi @actzikas ,

I hope I'm interpreting your question, right? From the looks of it you wish to Join or Combine two tables into one query?

As you haven't stated what columns [Table 2] contains or what your output table might look like - I’ll signpost you to a great video by @reza_rad (links below) where he explains the difference between the two types of combining query options available in Power BI; A: "Merge", and B:"Append".

If I may also suggest using the functions already accessible on the Home menu. It is much easier than writing your own "M" script (however, it can be done via the "Table.NestedJoin" function for merge or for append “Table.Combine”.)

Links to more info

Reza Rad Blog on:

Append vs. Merge in Power BI and Power Query: https://radacad.com/append-vs-merge-in-power-bi-and-power-query

Reza YouTube Video:

Append vs Merge in Power BI and Power Query: https://www.youtube.com/watch?v=qXH4WjCykLc

Microsoft Docs - Power Query functions reference:

Append (Table.Combine): https://docs.microsoft.com/en-us/powerquery-m/table-combine

Merge (Table.Join): https://docs.microsoft.com/en-us/powerquery-m/table-join