Hi guys, Welcome to the Advanced Video Search Engine, and you are watching Combine Files from a Folder with Power Query the RIGHT WAY!. That video is uploaded by MyOnlineTrainingHub at 2023-05-23T04:45:02-07:00. We are promoting this video only for entertainment and educational purpose only. So, I hope you like & enjoy it. [Nbhd0B5ldJE]
| Name | Combine Files from a Folder with Power Query the RIGHT WAY! |
| Video Uploader | Video From MyOnlineTrainingHub |
| Upload Date | This Video Uploaded At 23-05-2023 11:45:02 |
| Video Discription | Most people combine files from a folder with Power Query all wrong. In this video I show you why itโs wrong and the way you should be doing it. When Power Query combines files in a folder it automatically creates a bunch of queries for you. There are two queries that are important, the sample file query and the final query. Most people use the wrong query to make their transformations and wonder why theyโre struggling. Check out the video to see examples of when and why you should use the sample file query vs the final query. ๐FILE DOWNLAD & STEP BY STEP written instructions here: https://www.myonlinetraininghub.com/power-query-get-files-from-a-folder ๐ LEARN MORE in my Excel courses: https://www.myonlinetraininghub.com/ ๐ SUBSCRIBE if youโd like more tips and tutorials like this. ๐ข Please leave me a COMMENT. I read them all! ๐ฏ CONNECT with me on LinkedIn: https://www.linkedin.com/in/myndatreacy/ ๐ SHARE this video and spread the Excel love. Or if youโre short of time, please click the ๐ ๐ฌ EXCEL QUESTIONS: Get help on our Excel Forum: https://www.myonlinetraininghub.com/excel-forum โฒ TIMESTAMPS 0:00 How to Combine Multiple Excel Files From a Folder 0:20 The Data & Where to Save it 1:08 Getting the Data From a Folder 3:01 The Important Queries 3:57 When to use the Sample Query 7:36 The Important Stuff 7:53 Loading the Data 8:51 Getting New Data Nbhd0B5ldJE |
| Category | Science & Technology |
| Tags | Science & Technology Download MP4 | Science & Technology Download MP3 | Science & Technology Download MP4 360p | Science & Technology Download MP4 480p | Science & Technology Download MP4 720p | Science & Technology Download MP4 1080p |
