Home

A Question about Power Query

%3CLINGO-SUB%20id%3D%22lingo-sub-386818%22%20slang%3D%22en-US%22%3EA%20Question%20about%20Power%20Query%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-386818%22%20slang%3D%22en-US%22%3E%3CP%3EI%20am%20looking%20for%20a%20Power%20Query%20Function%20that%20allows%20me%20to%20query%20a%20folder%20which%20has%20several%20excel%20files%20in%20it%20and%20return%20values%20located%20in%20specific%20Tables.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIn%20each%20excel%20File%20I%20have%202%20Tables%20called%20%22Table_1%22%20%26amp%3B%20%22Table_2%22.%20I%20want%20power%20query%20to%20return%20the%20values%20located%20in%20all%20of%20those%20tables%20(which%20are%20in%20the%20exact%20same%20format).%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESo%20far%2C%20every%20article%20I%20find%20out%20there%20only%20talks%20about%20connecting%20to%20a%20folder%20and%20grabbing%20the%20raw%20excel%20data.%20I%20DO%20NOT%20WANT%20THAT.%20I%20want%20to%20specifically%20point%20the%20query%20to%20the%20above%20two%20mentioned%20tables%20ONLY.%20There%20could%20be%20other%20files%20in%20this%20folder%20I%20do%20not%20care%20about.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EFor%20the%20life%20of%20my%20I%20cannot%20find%20any%20articles%20on%20this.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-386818%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EPower%20Query%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3Epowerquery%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-386871%22%20slang%3D%22en-US%22%3ERe%3A%20A%20Question%20about%20Power%20Query%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-386871%22%20slang%3D%22en-US%22%3E%3CP%3EHi%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F307499%22%20target%3D%22_blank%22%3E%40raphael94%3C%2FA%3E%26nbsp%3B%2C%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EPower%20Query%20takes%20only%20one%20object%20from%20each%20file%2C%20that%20could%20be%20sheet%20or%20table.%20If%20you'd%20like%20to%20combine%20Table1%20from%20first%20file%20with%20Table1%20from%20second%20one%2C%20you%20need%20two%20queries.%20For%20Table1%20-%20click%20on%20Transform%20data%20(or%20Edit%2C%20depends%20on%20version)%20instead%20of%20Load%2C%20filter%20your%20files%20if%20you%20have%20other%20ones%20in%20folder%2C%20remove%20all%20columns%20but%20Content%2C%20combine%20it%20and%20select%20Table1%20on%20first%20step%20of%20the%20wizard.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3ERepeat%20the%20same%20for%20Table2%20with%20new%20query.%3C%2FP%3E%3C%2FLINGO-BODY%3E
raphael94
Occasional Visitor

I am looking for a Power Query Function that allows me to query a folder which has several excel files in it and return values located in specific Tables.

 

In each excel File I have 2 Tables called "Table_1" & "Table_2". I want power query to return the values located in all of those tables (which are in the exact same format).

 

So far, every article I find out there only talks about connecting to a folder and grabbing the raw excel data. I DO NOT WANT THAT. I want to specifically point the query to the above two mentioned tables ONLY. There could be other files in this folder I do not care about.

 

For the life of my I cannot find any articles on this.

1 Reply

Hi @raphael94 ,

 

Power Query takes only one object from each file, that could be sheet or table. If you'd like to combine Table1 from first file with Table1 from second one, you need two queries. For Table1 - click on Transform data (or Edit, depends on version) instead of Load, filter your files if you have other ones in folder, remove all columns but Content, combine it and select Table1 on first step of the wizard.

 

Repeat the same for Table2 with new query.

Related Conversations
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
13 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
22 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies