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 DanFromMontreal ,
so you are not speaking of one specific query here that you want to change, but to create multiple different queries?
Then I am with lbendlin here: Approach it with the FromFolder import instead of single file import: This not only allows you to extract the desired additional information, but also enables you to use one shared function allowing similar transformation of data - if that is desired.
lbendlin : I don't know why that comes back empty - but Value.Metadata is the only function I know that could do this job.