Hi All,
let
Source = Csv.Document(File.Contents("\\company.com\dfs\data\WM\CR\Shared\CPM\20240419TESTFILE.csv"),[Delimiter=",", Columns=24, Encoding=1252, QuoteStyle=QuoteStyle.None]),
#"Promoted Headers" = Table.PromoteHeaders(Source, [PromoteAllScalars=true]),
#"Changed Type"
I Have created a connection to a CSV file using the above code.
The issue I have is that a new source file is created daily and is named YYYYMMDDTESTFILE.
Can someone please tell me how I amend the code so that when I run the query, the source file name updates dynamically to todays date?
Many Thanks in advance
Bookmarks