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

Alansidman · #1 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

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