Forum Discussion

MRBranco's avatar
MRBranco
Frequent Visitor
6 years ago
Solved

Loading data from folder and add new column with Path Folder

Hi,

I need help to load data from folder and add new columns with folder path.

 

I have a folder [C:\Report] and subfolders [Joe, Mike, Paul]:

Folder

 

In each subfolder I have a Excel file as a report.

file

 

In each Excel file I have just two columns (with different values):

contents

 

I imported the folder and combined the Excel files:

folder imported

 

files combined

 

Now, I need a new column in the table that was combined with Path Folder:

new column

 

Thanks for any help.
MRBranco

Need Help
  • v-yingjl's avatar
    v-yingjl
    6 years ago

    Hi MRBranco ,

    Just select 'Removed Other Columns1' step in Applied steps and click the 'Folder Path' field to get the result:

     

    Best Regards,
    Yingjie Li

    If this post helps then please consider Accept it as the solution to help the other members find it more quickly.

3 Replies

  • parry2k's avatar
    parry2k
    Super User
    6 years ago

    MRBranco paste the M code from advanced editor, probably one of the steps has removed the column and in tht step you should not remove this path column and that will do it.

     

    I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem. It is a token of appreciation!

    ⚡Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡

  • v-yingjl's avatar
    v-yingjl
    Community Support
    6 years ago

    Hi MRBranco ,

    Just select 'Removed Other Columns1' step in Applied steps and click the 'Folder Path' field to get the result:

     

    Best Regards,
    Yingjie Li

    If this post helps then please consider Accept it as the solution to help the other members find it more quickly.