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.
Power Query
Power Pivot
Xtreme Pivot Tables
Excel for Decision Making
Excel for Finance
Excel Analysis Toolpak
Power BI
Excel
Word
Outlook
Excel Expert
Excel Customer Service
November 8, 2013
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 ?
Power Query
Power Pivot
Xtreme Pivot Tables
Excel for Decision Making
Excel for Finance
Excel Analysis Toolpak
Power BI
Excel
Word
Outlook
Excel Expert
Excel Customer Service
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)