after 6.04 merging two tables consider that two table as one and create new coonection instead of creating a table go on create new query and combine that with already created connection
If I want to join data between two tables with multiple fields. Do I need to use the same "Field Name" between two tables? Or how can i write down the join condition statement by my self?
I hv 5 excel sheet and have same code in 5 excel sheet but with different value in that code for all 5 excel sheet how can i merge 5 excel sheet values into one with 5 excel value ? I need your help?
Is it possible to specify relative file path? I have issue many times when i send these files to others and its will error as "File could not be found".
I am trying to create a power query but major problem when i merge two files i have more lines than the 1st file . The is the left all and matching from 2nd the first option. Have 3000+ entries in the 1st filed and the final merged file has 9000+ row. Please adv the reason for this error
Get Certified in Advanced Excel (Power Query):bit.ly/3LdiidF
Use coupon "RUclips12" to get ‘’FLAT 12%’’ OFF at Checkout.
Very well explained. A layman / beginner can also understand it easily. Thx a lot
You made my project so easy, my director give me 7 days to complete the project and it takes 1.5 days to complete. Thanks and love
Mama super video yar ...ultimate help yar ...i made my job so eary yar ..thank you so much ..
Thank you Mr. Lalwani, you're a brilliant teacher. Your tutorials have helped me do my job better every day!
please make more videos your videos are really helpful
Thanks a lot Sir 🎉🎉🎉🎉❤❤❤
Thank You For sharing Knowledge. Its really Useful.
Excellent Pavan ji...
These series are vey very useful
It was very simple and helpful. Thanks
Wow... It's amazing.
Thanks a lot Sir for such great explanation and knowledge sharing.
Thanks
Very good tutor 👍
Helpful.. many many thanks.
Tutorial points explanation are clear and simple here I have query what I want to merge more than 2 excels, how to merge more than 2 excels.
after 6.04 merging two tables consider that two table as one and create new coonection instead of creating a table
go on create new query and combine that with already created connection
Thank you! Your videos are just amazing👍
Could you please provide some sample data for practice with your videos
Great video. Your explanations cleared up the questions I had with power query. Thank you.
Thank You Sir
Sir you should also provide exercise files to practice along with you
Superb explanations
thanx
Thank you, sir! Could you please share the same sheet for practice?
Good
Excellent video - it works very well.
Best Explanations Sir
This is great!! Thank you so much.
It is creating cross join, creating multiple same records, what should we do?
very usefull
Hi i have a query -----How to schedule Refresh in Excel Power Query while file is closed?
Awesome !!!
i have 2 tables, from table one i have to multiply a single cell to entire column to another table on a timeline scale.
If I want to join data between two tables with multiple fields. Do I need to use the same "Field Name" between two tables? Or how can i write down the join condition statement by my self?
Can Anyone tell me where can I get data sheets for Excel practice?
i completed 1k like
How did you create the touch effect on extended display?
Can we do this with VBA?
I hv 5 excel sheet and have same code in 5 excel sheet but with different value in that code for all 5 excel sheet how can i merge 5 excel sheet values into one with 5 excel value ?
I need your help?
Is it possible to specify relative file path? I have issue many times when i send these files to others and its will error as "File could not be found".
How can I solve if duplicate value in both the table
awesome, besides, you didnt make any mistakes when you explained, you are a profi.
I tried but the changes in the original file is not linked to final file.
Will it still work if we change the source file name?
No it will not
I am trying to create a power query but major problem when i merge two files
i have more lines than the 1st file . The is the left all and matching from 2nd the first option.
Have 3000+ entries in the 1st filed and the final merged file has 9000+ row.
Please adv the reason for this error
i think you forgot to uncheck the output sheet
Very Helpful. Thanks
Awesome !!!