Power Query - Combine tables without Merging 🔗🧲

👋 Hey there, Data Enthusiasts! 👋

📊 Welcome to another episode of Ba Sensei Power Query Tutorials! Today, we're diving deep into a game-changing technique: combining two tables WITHOUT using the Merge function! 🎉

🔗 Resources & Links 🔗
Sample file

mquery funcitons used

#dataanalytics #data #datacleaning #mquery #powerquery #powerbi #powerbidesktop

[txreal]

I have a csv and Excel table of the SAME data; except the header row is different. Size is 300K rows x 25 columns
Ex: in csv column A called Owner, in Excel column A is called Owner ID, etc...
Should I Combined as you shared or Skip Row to be more efficient? Thanks.

[garywilhelm]

As always, a thoughtful video with great instruction. Bravo! Two comments. First, wonder why first step (Source) is set equal to null when first step could be the first real step (Table1); although you can't rename Source to Table1 in the Applied Steps window, you can do it in the Advanced Editor. Second, I hope viewers are not confused by James showing the Table.Column function in the Microsoft documentation when he no doubt really meant to show the Table.ToColumns function, which is the one actually used in the code. Although similar, the two functions are different.

[davidb]

I learned some functions here. Thanks.
Where would I use this instead of Merge?

[michaelangellotti]

As an old data guy who is newish to Power Query, I find your content very interesting. I t always makes me think how I can improve my queries or utilize your ideas in a way I haven't imagined. Keep up the good work.

[Sumanth]

Nice, will it work if the table has more then one column ?

[SndfOmar]

Wow! That's really amazing. 👏 Thanks dude.

[patrickyoung]

1K subs for the Purple Prince of Power Query! Improving with each bite-size crunch of data munching