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

[@kashisharora4563]

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

[@Innozant]

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

[@mjaved701]

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

[@Innozant]

Thanks Javed ji

[@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

[@iamsainipawan]

Sir you are truly superstar of excel🙏

[@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

[@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

[@ashishshiriskar123]

You are true Excel Guru🙏 sir

[@Innozant]

Thanks dear

[@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

[@syed599]

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

[@Innozant]

Thanks Syed..Happy learning dear

[@amansinha19891]

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

[@Innozant]

Thanks Aman .Happy Learning ❤️🙏

[@satishojha6240]

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

[@Innozant]

Thanks dear Satish ji🙏❤️

[@siddharthsatbhadre]

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

[@Innozant]

Thanks Siddharth Ji❤️

[@manojkumarsingh3385]

You are Magician in Excel 🙏🙏🙏

[@Innozant]

Thanks Dear🙏❤️

[@saqibaslam2431]

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

[@Innozant]

Thanks 👍🙏❤️

[@TheSuvankarKundu]

Sooo much thaku for helping to improve my life..

[@Innozant]

Thanks Suvankar🙏❤️

[@robbysandhu4425]

Beutifully explained sir. Appreciate

[@VipulJain40]

Dhanywad Guruji 🙏

[@acommonman155]

You're just awesome GURU JI as always 🙏

[@Innozant]

Thanks

[@excel_point]

Bhut Bhut Bhut Dhanyawad sir

[@Innozant]

Thanks Vikas

[@VikramSingh-fl4qe]

❤️ Very informative video..Thanks

[@Innozant]

Thanks Vikram❤️

[@shoryaarora1464]

Wow love the way of explain. Thank you 😊

[@Innozant]

Thanks Shorya🙏❤️

[@chiragpoddar9454]

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

[@Innozant]

Thanks Chirag ji🙏❤️

[@skdonsingh]

Well explained Thanks sir

[@omnarayan7066]

Gajab 🎉

[@nileshchavan742]

Very useful 👍

[@rohitdubey90]

U r great sir

[@rakeshmlearningentertainme6099]

nice video

[@dmeyufta3415]

very nice--join---thanks

[@anilnayak3328]

Thank you so much sir.🙏

[@Innozant]

Thanks Anil ji

[@horrorlovestories]

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

[@Innozant]

It depends

[@kapiltakkar8861]

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

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

[@kishorpanara4191]

Excellent Thanks sir

[@Innozant]

Thanks Kishor

[@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?

[@Travelroutexplore]

Wonderful after watching 5 times I understood joins😂

[@Innozant]

👍

[@siddharthsatbhadre]

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

[@Innozant]

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

[@khalidmajeed2886]

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

[@Innozant]

Will teach you soon.❤️

[@ajaysaroha2539]

Wah guru ji wah

[@Innozant]

Thanks Ajay

[@tahajasden1948]

thanks sir

[@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 ?

[@meriawaazhindi5217]

❤️❤️❤️❤️❤️

[@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

[@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.

[@aakasharya8352]

mast

[@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

[@RahulRoy-po9ct]

🙏

[@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

[@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

[@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.

[@iamir2647]

i don't get this join data

[@Innozant]

Which version of excel you are using now

[@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

[@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?

[@sawaimalhi8439]

sir is ki file nhe mil rhy hai please share krn

[@Innozant]

Wahin rakha hai folder me

[@itsdumpy]

aap insan nahi bhagwan ho

[@Innozant]

Happy Learning..God bless you Abhishek ji