Results 1 to 2 of 2

Thread: Excel power query
Thanks Thanks: 0 Likes Likes: 0

  1. #1
    Board Regular
    Join Date
    Apr 2012
    Posts
    77
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Excel power query

    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

  2. #2
    Board Regular
    Join Date
    Jan 2012
    Posts
    848
    Post Thanks / Like
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Excel power query

    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.

Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •