Forum

Power Query how to ...
 
Notifications
Clear all

Power Query how to select a Tab while using "from folder"

2 Posts
2 Users
0 Reactions
231 Views
(@psarna)
Posts: 1
New Member
Topic starter
 

Hello,

 

If I use Power Query and then use "from folder" to get Data , how and where do I define which Tab of the files in the folder to use?

 
Posted : 05/09/2018 4:00 pm
(@mynda)
Posts: 4761
Member Admin
 

Great question, Puran.

1. At the 'Combine Files' dialog box select any item from the list, then select the folder icon above. The right-hand pane should say 'No item selected for preview'. See image attached. Then click OK.

2. In the Power Query editor filter out the 'Name' column items you don't want to include.

3. Click the double arrow icon on the 'Data' column.

You will now have all of the data and just need to remove the columns you don't need.

Mynda

 
Posted : 05/09/2018 7:46 pm
Share: