Excel power query

[ldarley]

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

 

[theBardd]

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.