Forum Discussion
Add column with PowerQuery file name
how to add a column in PowerQuery automatically bringing the file name (excel spreadsheet)? I merged several tables into one, and I need to know which table the general table row belongs to
Hi denisluan
Check this out:
https://techcommunity.microsoft.com/t5/excel/power-query-source-from-relative-paths/m-p/206150
Please mark the question solved when done and consider giving kudos if posts are helpful.
Contact me privately for support with any larger-scale BI needs, tutoring, etc.
Cheers
2 Replies
- AlB
Community Champion
Hi denisluan
Check this out:
https://techcommunity.microsoft.com/t5/excel/power-query-source-from-relative-paths/m-p/206150
Please mark the question solved when done and consider giving kudos if posts are helpful.
Contact me privately for support with any larger-scale BI needs, tutoring, etc.
Cheers
THIS IS FOR ONLY FILE NO HEADERS
= (Path as text) =>
let
FileName = "PATH","\XXXX_",".txt", {0, RelativePosition.FromEnd}, 0),
Txt = Csv.Document(File.Contents("PATH"),[Delimiter=" ", Encoding=1252, QuoteStyle=QuoteStyle.None]),
Table.FromList=Table.AddColumn (Txt),
FileNameColumn=Table.AddColumn(Txt,"FileName",each FileName)
in
FileNameColumn
