Power Query Joins Explained | Types of Joins, Merges in Power Query | BI

[@mjaved701]

Excellent sir. May GOD bless you more and more for your efforts. 👏👏👏👏

[@Innozant]

Thanks Javed ji

[@kashisharora4563]

Now i am Very very well understand this matching concept now.....💥thkuu soo much sir♥️

[@Innozant]

Thanks Kashish..Tc..Good Night.. Happy Learning 🙏❤️

[@Azhar_Khan383]

I was really confused about this topic but now after watching this video everything is clear. Thank You, Sir

[@Innozant]

Thanks Azhar sahab❤️

[@devangthakkar6847]

Dear Sir - Superb learning and clear all outer joints. Thanks.

[@Innozant]

Thanks Devang .God bless You dear..Keep learning and Keep Exploring

[@DEADYBOYS]

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 ❤❤

[@Innozant]

Thanks dear

[@DEADYBOYS]

@@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 KZbin pr

[@syed599]

Excellent sir. May GOD bless you more and more for your efforts

[@Innozant]

Thanks Syed..Happy learning dear

[@ashishshiriskar123]

You are true Excel Guru🙏 sir

[@Innozant]

Thanks dear

[@sandeepaswal8944]

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.

[@Innozant]

Thanks Sandeep ji .nice to see you are again on track with full energy

[@jitendersharma727]

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.

[@Innozant]

Thanks foe yiue valuable feedback and suggestion. Will work on that foe sur..Keep Leaening and Keep exploring

[@manojkumarsingh3385]

You are Magician in Excel 🙏🙏🙏

[@Innozant]

Thanks Dear🙏❤️

[@iamsainipawan]

Sir you are truly superstar of excel🙏

[@saqibaslam2431]

Great sir thank you very much ap ne aj bht bari confusions clear kr di.🙏🥰

[@Innozant]

Thanks 👍🙏❤️

[@amansinha19891]

Thankyou sir...Bahut jada easy way me samajh aa gya sir..

[@Innozant]

Thanks Aman .Happy Learning ❤️🙏

[@siddharthsatbhadre]

Best explained, thanks sirji😊😊🙏🙏🙏🙏🙏🙏

[@Innozant]

Thanks Siddharth Ji❤️

[@robbysandhu4425]

Beutifully explained sir. Appreciate

[@acommonman155]

You're just awesome GURU JI as always 🙏

[@Innozant]

Thanks

[@TheSuvankarKundu]

Sooo much thaku for helping to improve my life..

[@Innozant]

Thanks Suvankar🙏❤️

[@satishojha6240]

It very similar to sql but power query smooth to compare than thanku very much sir 🙏🙏🙏. Good night

[@Innozant]

Thanks dear Satish ji🙏❤️

[@VikramSingh-fl4qe]

❤️ Very informative video..Thanks

[@Innozant]

Thanks Vikram❤️

[@shoryaarora1464]

Wow love the way of explain. Thank you 😊

[@Innozant]

Thanks Shorya🙏❤️

[@excel_point]

Bhut Bhut Bhut Dhanyawad sir

[@Innozant]

Thanks Vikas

[@chiragpoddar9454]

Great learning experience. Eagerly waiting for future videos for learning concepts in-depth

[@Innozant]

Thanks Chirag ji🙏❤️

[@skdonsingh]

Well explained Thanks sir

[@dmeyufta3415]

very nice--join---thanks

[@nileshchavan742]

Very useful 👍

[@horrorlovestories]

Sir 6:00 pe use original column as prefix uncheck karna hai ki nahi is data set mein?

[@Innozant]

It depends

[@rohitdubey90]

U r great sir

[@kishorpanara4191]

Excellent Thanks sir

[@Innozant]

Thanks Kishor

[@VipulJain40]

Dhanywad Guruji 🙏

[@anilnayak3328]

Thank you so much sir.🙏

[@Innozant]

Thanks Anil ji

[@kapiltakkar8861]

Is there any playlist on your channel for basics of Power BI

[@Travelroutexplore]

Wonderful after watching 5 times I understood joins😂

[@Innozant]

👍

[@omnarayan7066]

Gajab 🎉

[@jayantabhattacharyya628]

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

[@Innozant]

Thanks Jayanta..Will share more videos on thiss soon

[@eighttech]

Thanks you 🙏

[@rakeshmlearningentertainme6099]

nice video

[@shrikantbadge3978]

Amazing sir thank u

[@nileshchavan742]

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?

[@siddharthsatbhadre]

Main aap se VBA ,aur computer language sikhna chaunga..🙏🙏🙏

[@Innozant]

Jaroor Siddharth ji❤️..Live classes join kar skte hain aap humare

[@arjungupta0811]

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 ?

[@R_K_ENTERTAINMENT]

What method we use if we want to merge only unique value from both table

[@Innozant]

Soon you may able to see more videos for the same.

[@khalidmajeed2886]

i am looking for it. great sir, how to use complex vlookup in power query

[@Innozant]

Will teach you soon.❤️

[@samirawati1975]

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

[@Innozant]

Haan kar skte hain..file kahin bhi ho even subfoldet me tab bhi koi issue nahi hai

[@samirawati1975]

@@Innozant thanks of reply sir, Power query ka micro bana skate hay kya

[@ajaysaroha2539]

Wah guru ji wah

[@Innozant]

Thanks Ajay

[@tahajasden1948]

thanks sir

[@ManjeetSingh-th4fu]

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 🙏🙏

[@Innozant]

Hai dear. Assignment master me playlist folder name hue hain

[@nagulapallykumar2401]

Good

[@aakasharya8352]

mast

[@dishupal9443]

Sir mera merge query and new wala option nhai aa rha please help me

[@Innozant]

Kaunsa excel version hai aapka

[@dishupal9443]

2016

[@dishupal9443]

Sir please help me excel 2016

[@meriawaazhindi5217]

❤️❤️❤️❤️❤️

[@abhinav10x]

दोनों 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?

[@iamir2647]

i don't get this join data

[@Innozant]

Which version of excel you are using now

[@ahphotoworlds404]

Dear Sir Please Upload MS Word Developer Tab Tutorial

[@Innozant]

Ok..

[@ahphotoworlds404]

@@Innozant Dear Sir Kya MS Word Main ek page black white aur dusra page colour print ho Sakta Hain Kya

[@RahulRoy-po9ct]

🙏

[@manishjonwal1144]

Please powerbi data save as excel file please share me vedio

[@MohammedAbdulRaheem-jx3ki]

Sir apki ye practice file nhi hai description mein please uplooaadd kejiiye sir🎉🎉❤❤😢

[@Innozant]

Link hoga usme folder ke andar hoga

[@sawaimalhi8439]

sir is ki file nhe mil rhy hai please share krn

[@Innozant]

Wahin rakha hai folder me

[@deepraazshaw7369]

Sir, Mai clear nhi ho paya. Confused ho Gaye. Sir isko ekbar or clear karenge example ke sath. Thanks you sir

[@Innozant]

Oho .kyu .maine bht simple way me explain kiya hai..aap saare table dekhiye kaise aa ra hai ..aayega samaj.

[@itsdumpy]

aap insan nahi bhagwan ho

[@Innozant]

Happy Learning..God bless you Abhishek ji