Notifications
Clear all
Power Query
2
Posts
2
Users
0
Reactions
231
Views
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
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