Power Query - get single value from each of many files in folder

xor · #1 08-28-2024, 03:52 AM

Hello

In C:\Users\hansk\OneDrive\Desktop\Dokumenter\my_File s\Test2

I have 12 files and I want to extract the value in cell C1 (and only that) from each of the 12 files. Next month there may be 15 files in the folder and I then want to extract the value in C1 of these 15 files.

If at all possible I would much prefer a workbook with a working solution. Thank you.

Hans K.

Alansidman · #2 09-01-2024, 02:34 AM

Rather than have us blindly prepare a file for you, why dont you upload a sample file(s) for us to work with. In this manner, we will not have to guess at what your data looks like. Then for the file(s) submitted prepare a mocked up solution of what your file product should look like.

Without an example of your data, then perhaps

Code:

let
    T1 = Excel.CurrentWorkbook(){[Name="Table1"]}[Content],
    T2 = Excel.CurrentWorkbook(){[Name="Table2"]}[Content],
    T3 = Excel.CurrentWorkbook(){[Name="Table3"]}[Content],
    T4= Table.Combine({T3,T1,T2})

in
    T4

xor · #3 09-01-2024, 03:26 AM

My apologies
Please forget about it.

Hans K.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Power query not importing the corect atributes from windows folder	oscarlimerick	Excel	12	06-30-2024 07:21 AM
Power Query to get a list of folders (not files) in a location?	kilroyscarnival	Excel	13	02-24-2023 11:08 AM
Excel power query help	ganesang	Excel Programming	0	09-20-2021 01:50 AM
Do I need a power query for this one?	shabbaranks	Excel	5	04-10-2019 03:29 AM
Query and Power Query not working Excel 2016	bl10	Excel	0	07-22-2016 06:25 PM