Power Query Joins Explained | Types of Joins, Merges in Power Query | BI
Вставка
- Опубліковано 5 жов 2024
- Power Query Joins Explained | Types of Joins, Merges in Power Query | BI
Learn about 6 types of Joins in Power Query/Power BI
1. Left Outer Join
2. Right Outer Join
3. Full outer Join
4. Inner Join
5. Left Anti Join
6. Right Anti Join
Excel Power Query Playlist Link- • Excel Power Query
Download the Assignment Master Practice Folder here (All Playlist Example at one place)
drive.google.c...
Music: www.bensound.com
===========VIDEO COURSE============================
✅ Mastering Excel Video Course
www.innozant.c...
✅ Mastering Power BI Video Course
www.innozant.c...
✅ Mastering VBA Video Course
www.innozant.c...
✅ Mastering SQL Video Course
www.innozant.c...
Visit - innozant.com
=====================================================
===========HYBRID CLASSES============================
✅ आरंभ EXCEL | सक्षम Analytics | निपुण Analytics
✅ Database Training(SQL , PL\SQL , Oracle Developer)
✅ Mastering Data Science
Visit - innozant.com
====================================================
Videos in a Sequence -Basic to Advanced EXCEL
Basic Excel- • Basic Excel-The Learni...
Advanced Excel Sorting and Filter- • Advanced Excel Sorting...
Subtotal TTC and Data Validation- • Excel Subtotal TTC and...
Excel What if Analysis- • Excel What if Analysis
Excel Array and Sumproduct- • Excel Array & Sumprodu...
Excel Lookup Functions- • Excel Lookup Functions...
Excel Pivot Tables- • Excel Pivot Tables
Excel Power Pivot- • Excel Power Pivot
Excel Power Query- • Excel Power Query
Excel Chart and Infographics- • Excel Chart and Infogr...
Excel Dashboard & Reports- • Excel Dashboard & Reports
Value add-ons Playlist
ProQuest-Check Point- • Excel ProQuest-Check P...
Career Guide:सिफर से सिखर तक - • Career Guide-सिफर से श...
StudsTalk -The Journey begins- • StudsTalk-The Journey ...
QUIZ Sunday- • EXCEL MIS QUIZ SUNDAY
Excel Tips and Tricks- • Excel Tips & Tricks
MIS Interview Cracker- • MIS Interview Cracker
MIS Job Live Interview :Based on Real Incident- • MIS JOB Live Interview...
Excel Maharaj- • EXCEL MAHARAJ - For Ex...
Microsoft Powerpoint- • Microsoft Powerpoint
Microsoft Word- • Microsoft Word
Office 365- • Office 365
Google Sheets- • Google Sheets
Microsoft Outlook- • Microsoft Outlook
Power BI- • Power BI
Excel VBA- • Excel VBA Macro
TezXL Jata Shorts- • #shorts | जो TRIM के ब...
Announcements- • Announcements
Website - "www.innozant.com"
Let's Connect:
Instagram ► / innozantinfotech
Facebook ► / innozantinfotech
Telegram►t.me/innozanti...
#powerquery #powerqueryjoins#innozant #typesofjoineinpowerquery #excelpowerqueryjoinkind
Excellent sir. May GOD bless you more and more for your efforts. 👏👏👏👏
Thanks Javed ji
Now i am Very very well understand this matching concept now.....💥thkuu soo much sir♥️
Thanks Kashish..Tc..Good Night.. Happy Learning 🙏❤️
I was really confused about this topic but now after watching this video everything is clear. Thank You, Sir
Thanks Azhar sahab❤️
You are having amazing knowledge about Excel functionalities. If the accent and intonation of what you speak gets near to a normal way, it would be easier.
Thanks foe yiue valuable feedback and suggestion.
Will work on that foe sur..Keep Leaening and Keep exploring
Thanks you so much sir for your course on power query as it enable to strengthen my understanding about how to use power query in my daily job. Thanks again for your teaching and patience.
Thanks Sandeep ji .nice to see you are again on track with full energy
Dear Sir - Superb learning and clear all outer joints. Thanks.
Thanks Devang .God bless You dear..Keep learning and Keep Exploring
Sir ji thanks you aap ne is topic ko bahut achche se samjhaya aapki mehnat rang layi koi dino se is topic pr daut tha ab fully clear hai ❤❤
Thanks dear
@@Innozant sir ji ek aap se request hai Office 365 me data tab me Forecast sheet topic pr ek video creat kre abhi mujhe ap ke channel pr uska video nhi mila or ma UA-cam pr
Excellent sir. May GOD bless you more and more for your efforts
Thanks Syed..Happy learning dear
Sir you are truly superstar of excel🙏
You are true Excel Guru🙏 sir
Thanks dear
Beutifully explained sir. Appreciate
Sooo much thaku for helping to improve my life..
Thanks Suvankar🙏❤️
Thankyou sir...Bahut jada easy way me samajh aa gya sir..
Thanks Aman .Happy Learning ❤️🙏
You are Magician in Excel 🙏🙏🙏
Thanks Dear🙏❤️
Great learning experience. Eagerly waiting for future videos for learning concepts in-depth
Thanks Chirag ji🙏❤️
Is there any playlist on your channel for basics of Power BI
You're just awesome GURU JI as always 🙏
Thanks
It very similar to sql but power query smooth to compare than thanku very much sir 🙏🙏🙏. Good night
Thanks dear Satish ji🙏❤️
Great sir thank you very much ap ne aj bht bari confusions clear kr di.🙏🥰
Thanks 👍🙏❤️
Dear Sir
Thanks for explaining different types of merges in power query so well. I have understood merge and append query after watching your tutorials. Sir, can I use logical function in power query? Kindly upload videos on this topic.
Thanks & Regards
Jayanta Bhattacharyya
Thanks Jayanta..Will share more videos on thiss soon
U r great sir
Well explained Thanks sir
very nice--join---thanks
Dhanywad Guruji 🙏
Best explained, thanks sirji😊😊🙏🙏🙏🙏🙏🙏
Thanks Siddharth Ji❤️
nice video
Amazing sir thank u
Wow love the way of explain. Thank you 😊
Thanks Shorya🙏❤️
Thanks you 🙏
Very useful 👍
Excellent Thanks sir
Thanks Kishor
Very nice sir, agar mai main data file me change karta hu to jo join kind karne ke baad data aata hai usme bhi change hota hai?
Bhut Bhut Bhut Dhanyawad sir
Thanks Vikas
❤️ Very informative video..Thanks
Thanks Vikram❤️
i am looking for it. great sir, how to use complex vlookup in power query
Will teach you soon.❤️
Main aap se VBA ,aur computer language sikhna chaunga..🙏🙏🙏
Jaroor Siddharth ji❤️..Live classes join kar skte hain aap humare
thanks sir
Gajab 🎉
Wonderful after watching 5 times I understood joins😂
👍
Thank you so much sir.🙏
Thanks Anil ji
Good afternoon sir. Agar hum right outer join ka use krte ha toh table 2 first lege aur table second lege then right outer join krege ?
Good
Thanks you sir for this video
But, sir there is no assignment of this video mentioned in assignment master sheet
Plz share practice assignment of this video 🙏🙏
Hai dear.
Assignment master me playlist folder name hue hain
What method we use if we want to merge only unique value from both table
Soon you may able to see more videos for the same.
mast
Sir 6:00 pe use original column as prefix uncheck karna hai ki nahi is data set mein?
It depends
Wah guru ji wah
Thanks Ajay
Hi sir, very nice information
Muze 1 problem tha, kya power quiry ki madat se file path aur table ek hi sheet pe join ho sakte hay,
For example d:/test/filename.tif | sr number | product | qty |
File contain more than 2 sheet
Please help
Haan kar skte hain..file kahin bhi ho even subfoldet me tab bhi koi issue nahi hai
@@Innozant thanks of reply sir,
Power query ka micro bana skate hay kya
🙏
❤️❤️❤️❤️❤️
Dear Sir Please Upload MS Word Developer Tab Tutorial
Ok..
@@Innozant Dear Sir Kya MS Word Main ek page black white aur dusra page colour print ho Sakta Hain Kya
Please powerbi data save as excel file please share me vedio
दोनों table ka common data merge karne pe double ho ja raha hai, aur second table me bhi same ho ja raha, e.g. 1st table ke Primary column me "Agra" ka 6 row hai, 2nd column me 2 row hai "Agra" ka, merge karne pe ye 12 row add kar le raha hai, mistake kaha ho raha? Please guide
Query2: - अगर दोनों table के सभी column name same ho to join run karega?
Sir, Mai clear nhi ho paya. Confused ho Gaye.
Sir isko ekbar or clear karenge example ke sath.
Thanks you sir
Oho .kyu .maine bht simple way me explain kiya hai..aap saare table dekhiye kaise aa ra hai ..aayega samaj.
Sir mera merge query and new wala option nhai aa rha please help me
Kaunsa excel version hai aapka
2016
Sir please help me excel 2016
sir is ki file nhe mil rhy hai please share krn
Wahin rakha hai folder me
aap insan nahi bhagwan ho
Happy Learning..God bless you Abhishek ji