➕ Append vs Merge 🔗 - Which one to use

How to choose the right one? Easy!

First, we have to understand what is the difference between the two of them.
One of them is going to COMBINE queries, while to other one works similarly to LOOKUP in Excel 🧠

You have probably guessed it right. Append is going to combine queries while Merge can help us to lookup values from other queries.

I hope that this video helps you to have a better understanding of these great Power Query features.

Have a good one,
Roland

💪 New videos coming every Tuesday 🤹‍♂‍

🔗 REFERENCE MATERIAL
*Source: SqlJason

🎬 MORE VIDEOS:

▼▼▼▼▼▼▼▼▼
Make sure to hit the 👍 button and ❗❗ SUBSCRIBE ❗❗ to my channel.
If you have any questions, just let me know either in the comments down below 👇 or send us an e-mail 📩.
▲▲▲▲▲▲▲▲▲

🤝 HOW TO CONNECT 🤝
📍 – Sydney, Australia

📽 GEAR:
📷 – Canon EOS 200D
🎙 – Audio Technica AT2020
🔦 – Neewer 18” Ring Light
🎧 – BOSE QC35
🖥 – 2x ASUS VC279H
💻 – AMD Ryzen 3600, Gigabyte X570, GTX1650, G.Skill 32GB RAM

#AppendvsMerge #PowerBI #BI-LingualAnalytics #BusinessIntelligence #DataScience #Data #DataAnalytics #Analytics #BI

[TheShaddy]

This really helped out with understanding this concept, thanks!