Hi All,
I am trying to convert a bit of code that uses cells to hold the Folder Path and File Name. This works perfectly for Excel files. I am now trying to modify the code to import a csv fie, but failing. If anyone could offer any advice it would be much appreciated.
FilePath = Excel.CurrentWorkbook(){[Name="Folder_Path"]}[Content]{0}[Column1],
FileName = Excel.CurrentWorkbook(){[Name="File_Name"]}[Content]{0}[Column1],
Source = Excel.Workbook(File.Contents(FilePath & FileName), null, true),
FilePath = Csv.Document(){[Name="Folder_Path"]}[Delimiter=",", Columns=6, Encoding=1252, QuoteStyle=QuoteStyle.None],
FileName = Csv.Document(){[Name="File_Name"]}[Delimiter=",", Columns=6, Encoding=1252, QuoteStyle=QuoteStyle.None],[Content]{0}[Column1],
Source = Csv.Document(File.Contents(FilePath & FileName), null, true),
I am trying to convert a bit of code that uses cells to hold the Folder Path and File Name. This works perfectly for Excel files. I am now trying to modify the code to import a csv fie, but failing. If anyone could offer any advice it would be much appreciated.
FilePath = Excel.CurrentWorkbook(){[Name="Folder_Path"]}[Content]{0}[Column1],
FileName = Excel.CurrentWorkbook(){[Name="File_Name"]}[Content]{0}[Column1],
Source = Excel.Workbook(File.Contents(FilePath & FileName), null, true),
FilePath = Csv.Document(){[Name="Folder_Path"]}[Delimiter=",", Columns=6, Encoding=1252, QuoteStyle=QuoteStyle.None],
FileName = Csv.Document(){[Name="File_Name"]}[Delimiter=",", Columns=6, Encoding=1252, QuoteStyle=QuoteStyle.None],[Content]{0}[Column1],
Source = Csv.Document(File.Contents(FilePath & FileName), null, true),