

August 21, 2019

Hi Catalin / Mynda
Currently I got master table, each month we need to add the latest data in the master table (See attached AppendTables_tobePermanent.xlsx consist of Oct19 + Nov19)
As the Nov19 is always reference to MasterTable (Started from Oct 19), and when times go by, there will be a lot of queries, Dec19, Jan20, Feb20......
i was thinking whether there is a way to break the reference whenever a current month data append to the master, so I can only maintain a current query that point to a file call current.xlsx (Source), I just need to put in the data that need to copy/append to the master.


August 21, 2019

Hi Catalin,
I was not familiar with query from File> From Folder
manage to put Oct 19, Nov 19 to a folder
In the query
ContentNameExtensionDate accessedDate modifiedDate createdAttributesFolder Path
Binary.FromText(...) | Nov19.xlsx | .xlsx | 12/12/2019 2:03:15 PM | 12/12/2019 2:03:15 PM | 12/12/2019 2:02:19 PM | [Record] | C:\Users\User\Documents\PowerBI & PowerQuery\MyonlineTraining\Listing\ |
Binary.FromText(...) | Oct19.xlsx | .xlsx | 12/12/2019 2:08:51 PM | 12/12/2019 2:08:51 PM | 12/12/2019 2:00:39 PM | [Record] | C:\Users\User\Documents\PowerBI & PowerQuery\MyonlineTraining\Listing\ |
how to proceed from here ?


November 8, 2013

after you get the list of files in that folder, add a new column with the formula:
=Excel.Workbook([Content])
Then you will expand this new column.
You have a tutorial here: https://www.myonlinetraininghub.com/power-query-get-files-from-a-folder

Answers Post
1 Guest(s)
