While working through the previous example, you may have noticed the output includes files in the selected folder AND subfolders.īut what if we only want the files from the folder? With a small change to the M code, we can achieve this too.īy default, Power Query users the Folder.Files function. List files in a folder, but not Subfolders The Preview window now shows only a list of the files and folders.Ĭlick Home > Close and Load to push the data into Excel.īOOM! How easy was that! We didn’t need to write a single line of code □. With the Full File Path column selected, click Home > Remove Columns (drop-down) > Remove Other Columns.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |