Forum Discussion

DanFromMontreal's avatar
DanFromMontreal
Helper IV
4 years ago

Add column with the path&filename

Good day, I'm trying to add a column containing the folder & filename for each row of the dataset being imported .   I've tried this but does not return want I want.... = Table.AddColumn(#"Sales"...
Need Help
smpa01's avatar
smpa01
Community Champion
4 years ago

DanFromMontreal 

let
    Source = SharePoint.Files("https://xyz.sharepoint.com/teams/Analytics", [ApiVersion = 15]),
    sales = Table.SelectRows(Source, each [Name] = "sales.xlsx"),
    #"Added Custom" = Table.AddColumn(sales, "filePathName, each [Folder Path]&[Name])
in
    #"Added Custom"
  • DanFromMontreal's avatar
    DanFromMontreal
    Helper IV
    4 years ago

    Thank you for the fast response but unfortunately, I probably did not provide enough info on what I wanted.

    Let me rephrase....

    I'm importing data from a .CSV file located on my computer and/or a server using the Data>From a CSV file from Excel.

    This opens up the Power Query Editor.

    I transform the data as required (still good) but to know the path&filename of the file when I return to Excel, I would like to add a column on the far right containing this information.  If there is 267 rows of data, I will have 267 of the same information in the newly added column.

    This way, I will know for sure in Excel from where the data is coming from.

    If the change the source file or location, it will be obvious.

    Hope this is more clear.

     

    The file and location can be found, as you sure known, in the APPLIED STEPS > Source but I cannot figure out how to extract it

     

    Regards