+ Reply to Thread
Results 1 to 5 of 5

Excel and power query - Add column with filename?

  1. #1
    Registered User
    Join Date
    05-04-2011
    Location
    Chile
    MS-Off Ver
    Excel 2003
    Posts
    3

    Excel and power query - Add column with filename?

    Hello,
    I'm using ms office 2016 and I pretend to import multiple files from a folder.
    I can do it, but I can't overcome the task of creating a column with the filename.
    How can I produce that?
    Thanks for your time and interest.

  2. #2
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 2019
    Posts
    17,567

    Re: Excel and power query - Add column with filename?

    Not sure that I understand, however the first part of the linked video seems to be relevant.
    https://www.youtube.com/watch?v=ldoQws7Zbx8
    Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.

  3. #3
    Registered User
    Join Date
    05-04-2011
    Location
    Chile
    MS-Off Ver
    Excel 2003
    Posts
    3

    Re: Excel and power query - Add column with filename?

    Thanks.
    That's what I needed It.

  4. #4
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 Version 2405 Win 11 Home 64 Bit
    Posts
    23,888

    Re: Excel and power query - Add column with filename?

    If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.

    Also, you may not be aware that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of those who helped.
    Alan עַם יִשְׂרָאֵל חַי


    Change an Ugly Report with Power Query
    Database Normalization
    Complete Guide to Power Query
    Man's Mind Stretched to New Dimensions Never Returns to Its Original Form

  5. #5
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 2019
    Posts
    17,567

    Re: Excel and power query - Add column with filename?

    You're Welcome. Thank You for the feedback and for marking the thread as 'Solved'. I hope that you have a blessed day.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 10
    Last Post: 06-25-2020, 12:19 AM
  2. [SOLVED] Power Query - excel formula translation into Power Query
    By afgi in forum Excel Charting & Pivots
    Replies: 7
    Last Post: 02-19-2020, 03:38 AM
  3. Replies: 4
    Last Post: 02-17-2020, 06:03 AM
  4. [SOLVED] Power Query - Extract FileName for Full Path in Cell
    By jgarza0422 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 04-11-2019, 10:20 AM
  5. [SOLVED] Power Pivot does not load new column added in Power query
    By ibuhary in forum Excel General
    Replies: 12
    Last Post: 02-19-2019, 03:53 AM
  6. Sub-Forum for Excel Power Tools (Power Query, Power Pivot & Power BI)
    By chullan88 in forum Suggestions for Improvement
    Replies: 10
    Last Post: 06-28-2018, 02:25 PM
  7. Using weblink listed in excel column for Power Query
    By asha3010 in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 03-05-2017, 10:18 AM

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1