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

Last used cell?
Press Ctrl+End to move to what Excel thinks is the last used cell.

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,099,891
Messages
5,471,325
Members
406,757
Latest member
dizzane

This Week's Hot Topics

Top