Excel power query

ldarley

Board Regular
Joined
Apr 10, 2012
Messages
83
HI all,

I've generated a query from a folder containing dozens of workbooks. I'm using table 1 from each workbook, in the query editor I have all my data including the source workbook, but I want to add the filepath to each row. How to I add an extra column with the filepath inside the editor?

Many thanks for any suggestions
 

Some videos you may like

Excel Facts

Why are there 1,048,576 rows in Excel?
The Excel team increased the size of the grid in 2007. There are 2^20 rows and 2^14 columns for a total of 17 billion cells.

theBardd

Rules violation
Joined
Jan 21, 2012
Messages
912
In the code generated when you load and transform the files, you should see a step called 'Removed Other Columns' or similar. That should have a Table.SelectColumns function, just add ', "Folder Path"'(without the single-quotes) in the columns listed between the braces.
 

Watch MrExcel Video

Forum statistics

Threads
1,102,301
Messages
5,486,047
Members
407,529
Latest member
netojose

This Week's Hot Topics

Top