Forum Discussion
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"...
I guess I can help.
In Power Query Editor, you probably combine your files by pressing a button with 2 arrows in Content column.
If so, go to the step "Removed Other Columns" (Applied steps, right side), add "Folder Path" to the code and press enter.
Like this:
= Table.SelectColumns(#"Renamed Columns1", {"Folder Path", "Source.Name", "Transform File"})
It worked for me 🙂