Import Data from Text Files using Power Query in Excel
Вставка
- Опубліковано 12 вер 2024
- Learn how to Import Data from Text files using Power Query in Excel with traditional method and power query method.
Excel Power Query Playlist Link - • Excel Power Query
Download the Assignment Master Practice Folder here (All Playlist Example at one place)
drive.google.c...
===========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 #powerquerytutorial#innozant #powerquerystepby step#getandtransform#powerqueryimportdata
Thank you sir ,I learned a lot from your excel's tutorials, and now I started learning Power query Excellent tutorial.
Thanks Sandeep Ji,Happy Learning ❤️🙏
The way you teach things is Excellent sir. Thank you.Keep educating us sir
Thanks Harshitha , Really means a lot today me dear
I am extremely happy to know how to teach you, You are mind blowing, Great to see
Thanks Rohit ji..Happy Learning ❤️👍
fantastic!! Appreciate your compassion and support,the way you teach is amazing.
Thanks dear.Keep learning 👍
Excellent sir. Your method of teaching too much amazing.GOD bless you
Thanks Javed sahab..Happy learning
we get lots of classes about excel but ur teaching is amzng
Thanks Naseer Sahab ❤️👍
Very important series for data wrangling so pls continue it sir
Sure dear...❤❤🙏🙏
Thanks bro for ur support..It can not be able to learn PQ without you...need help in single cell move left or right ..
Apka tutorial se kafi helf milti hai
Thanks Pushpendra Ji🙏❤️
Great content and delivery
Wow,
You are real excel hero Sir🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏
Thanks for your appreciation Pawan.. happy learning
Wow.
It is nice idea.
Thanks sir 🙏🙏🙏🙏🙏🙏
Thanks dear.Happy learning
so nice i have no words for you really great work for all ..
Sir, thank you again for the power query tutorials, they are very well done and you the best at teaching.
I also have one question, when I copy query and paste it and change source, it does the same steps but output is incorrect . When I run the same steps again , output is correct. Why would this be the case? Pls advise
Wow sir what a explanation thank you so much.
Nice sir
Sir aap ye kabhi mt sochna ki meri video ko bahut kam Log dekhte hai . Aapke samjhane ka tareeka bahut mst hai ache se samajh me aata hai .Aapke video ko ek din ache views aayege . Aur ise bahut log dekhege . Plz conti....👍🏻🙏
Thanks for showing trust ,Love and support dear.. Love you all
Dear Sir
Thanks for uploading such excellent tutorial. It is a new topic to import text files in power query. I don't know that process of import text files before. Looking forward to some excellent power query tricks and topics.
Thanks & Regards
Jayanta Bhattacharyya.
Thanks Jayanta...Have a lovely day ahead..
Superb Sir. You are Great Mentor
Quite liked the tutorials given by you about power query. I found it very useful. Easy to understand. Do you also have any tutorial series for power apps & power BI ? Do you have any institute here in Delhi ?
Yes we are running Training institute at New Ashok Nagar Delhi ,You may visit Innozant website for more information or connect with Team Innozant on call/whatsapp
Mere pas sbd nhi h, tarif krne ke liye, bs yehi kahunga sir , jis bhi eswr ko mante ho aap wh apki seht bnaye rhe or yese content hme milte rhe..., Thank you from ❤
Thanks Amit ji.Keep learning ❤️
Excellent job brother
Thanks Sadiq.Happy learning
waah maza aa agaya,thanks
Its awesome sir.. Thanku so much..
Thanks Suvankar ji
Amazing thank u sir
Please add one step in this video. It is the step of linking Nov 17 data with Dec 17 data. Please accept my congratulations for explaining minor details in such a simple way. I have subscribed your channel. Keep it up.
Ok...👍❤️ thanks Rajeev ji for your valuable appreciation ❤️
TQ....SIR...JI..🙏🙏🙏🙏🙏🙏🙏
You are superb sir
Thanks Ajit ji❤️🙏
प्रणाम है गुरूजी आपको
great video
Nice 👍 Great Sir ji❤
Yuo are amazing sir
Dear sir, I have a CSV file of a Bank statement with more than 25 pages in it.Do Power query work on it.please suggest what to do.
Why not..You may import it in power query
When we changed the source data for dec file does the previous month data got removed???
Thanks 🙏
You are great
Thanks Kishor..Happy learning dear
You are the best sir Jee amazing topic thank you so much si
Thanks Vikash ji..happy learning
Great, this is not working in xlsx file ?
Sir Ur amazing 🙏🙏 thanks a lot🙏🙏
Thanks Abhishek Ji..Happy learning..good night
Sir, I am new to this series. i have some unstructured text documents. i am not getting different column while loading data in power query. i only find one col. I do not know how to make column in it
Syed sahab kindly watch complete playlist step by step
@@Innozant Thanks sir.
sir mere excel 2019 me load and combine ka option hai transform ka option nahi hai to kese karu?
sir i really expecting your feedback, what would i learn deeply, i found excel really hard but power query much easier for me ,
So please sir , give you kind guidence what would i learn excel or power query,
Excel + Power BI (includes Power query,power pivot & Data Visualization) both
i follwod all of the steps that you showd but can't add the dec file , i don't knwo where is the problem
sir do you have any say .
Sir ji thank you . Record 10.49 se samaj me nahi aaya.. aap ne data ko kyoo change kiay
🙏🙏🙏🙏🙏🙏👍👍👍👍👍👍 Thnq sir
Thanks Gaurav ji
Please help to load dynamic 365 CRM data in Excel m while connecting with api i am getting some odata error
sir csv.zip file ko kaise import kare from web se is per video banaeye
Jaise aur file impirt karte hain waise hi process web content download krne ke liye krenge
hello Sir,
Aap ka samjhane ka tareeka bohat acha hai aap excel ke expert hain aap se poochna tah mujhe
excel main open password lagta hai main chata hoon apne office main woh password boss ko batadoon lekin woh password
change na ho or na delete ho paye plz sir aap meri ye query solve karden plz...
Password jinxed Pata joga wo to edit karenge hi Aizaz sahab😁
@@Innozant Sir Tools main jaakar jo General option ata hai woh wahan se hide hojaye aisa vba ke through ho sakta hai kiya
superb sir 👌👌👌👌👌👌👌👌
Thanks ..
Sir My data is not getting properly in excel data . please suggest me.what to do. ??
Dear Sir,
I'm unable to pull the data from excel binary(.xslb) file to powerquery. but if i tried to excel workbook(.xlsx) file then it easily load the data what's the reason behind on it????? please help
👌🏼💞
Sir iski practice file kaise milega
Well-done
Thanks Aqeel Sahab...Happy Learning dear
How can we set automatically column width in power query?
First set word wrap ON then set auto size OFF.It may help you.
Sir vlookup me columns or rows ka ek sath use kaise kare
questions share karen with detail query innozantcampus@gmail.com
Sir I had mail my query with details
Sir jub hum excel ki asi files ko power query kay zaray import kartay hay jis many formula laga ho too import kay bay formula khutam ho jata ha. May chata hoon formula khutam na hoo. Plz guide.
Firmula khatak kajan hota hai..?rhta hi to h
@@InnozantSir plz start macros.
❤️❤️❤️❤️
Hello sir, I'm your new subscriber. I need your help. I'm a graduate in BA and right now am pursuing a course in Advanced excel with MIS. Please let me know what are the career scope and what should i learn next. Thank you in advance
Thanks Cynthia ,We welcome you to experience the taste of success.
kindly watch this video it will help you
ua-cam.com/video/Z-ElRbzWL2I/v-deo.html
@@Innozant Thank you so much sir. Your channel is really aspiring many people's and it's productive too. Am glad to have a quick response from you. Please accept my gratitude 🙏🙏🙏
SIR plz excel file upload kr dijiye
Bhai multiplication ka singh jo max product formula ma lagaya hai woh kaisa work karta hai barao comment ma
Kaunse question me..Video link dijiye..phir explain kr deta hu jo bhi aapki query hai...
@@Innozant max aur product formula wala video ma jo multiplication sign jo use hua hai uska bara ma kaisa work karta hai
Yadi aap sumproduct me --(double negative) use karte hain to wo coerce kar deta hai thats means true value jahan milega use 1 aur false ko 0 me convert kr dega lekin yadi array ka dimension same hoga to fine nhi to issue hoga..but asterisk(*) ke case me aisq nhi hoga..ydi array ka dimension alag bhi hoga to sahi chalega..aap sumproduct ke Playlist ko ek baar jaroor dekhen.
greaatttttt
Sir apki Power quiet ki video nhi arhi
Eveey week aa ri hai power video
May you live happily ever after. This is my prayer to God
Thanks Ranjit...Happy learning
@@Innozant really sir you are doing a great work.
Sir VBA & MACRO ka series kab daloge..
Sir please aap mujhe apna mobile number dijiye, mujhe aap se kuch excel se relented question puchne hai
Error aa raha hai
Kya error
👌💐💐🙏
Thanks Tejpal ji
Why do you have to put the title of the video in English if virtualy non of the content is spoken in English?
Because excel is in English, we understand both the languages equally
kya bhadhiya chij btayi h sir
TEXT FILE SEND KARO MUJHE
Download it from master assignment link given in video description
logo to sahi bna lo itna weird lag rha I
Kya aisa isme weired hai dear,kindly watch the content of you are really a dive deep learner,Happy learning ❤️
❤❤❤