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"...
Hi Anonymous ,
When you do the from-folder method, there will be some steps being auto-created. One of them should be "Remove other columns". To the right you will find a gearwheel. Click on it and you get a menu of columns to keep. Choose the name-column: