Add column with PowerQuery file name

[denisluan]

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

[JAGUAR88]

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

[AlB · Accepted solution]

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