Forum Discussion

DanFromMontreal's avatar
DanFromMontreal
Icon for Helper IV rankHelper 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
ImkeF's avatar
ImkeF
Icon for Community Champion rankCommunity Champion
3 years ago

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: