Forum Discussion
Giulianna
Helper I
Helper IImport multiple files from a folder that can be copied and used for different users
I am trying to create a tool for my team where the excel imports files from a folder which contains multiple tamplates and these templates are used to generate different queries, and with the queries...
If you add one line to CurrentFile it should work:
let Source = Excel.CurrentWorkbook(), MyFileName = Source{[Name="MyFileName"]}[Content], #"Renamed Columns" = Table.RenameColumns(MyFileName,{{"Column1", "Current File Name"}}), #"Extracted Text Before Delimiter" = Table.TransformColumns(#"Renamed Columns", {{"Current File Name", each Text.BeforeDelimiter(_, "["), type text}}), #"Current File Name" = #"Extracted Text Before Delimiter"{0}[Current File Name] in #"Current File Name"
PwerQueryKees
Super User
Super UserHard to see. Press go to error and share a screenprint in cluding the data,..
GiuliannaHelper I
Helper ISorry, here it is. I don't know if the problem is I have a lot of queries and helper queries too with samples, parameters and functions:
- PwerQueryKees
And what does CurrentDirectory look like? Open the query. I would like to see first and last step data.
- Giulianna
let
Source = Excel.CurrentWorkbook(),
MyFileName = Source{[Name="MyFileName"]}[Content],
#"Renamed Columns" = Table.RenameColumns(MyFileName,{{"Column1", "Current File Name"}}),
#"Extracted Text Before Delimiter" = Table.TransformColumns(#"Renamed Columns", {{"Current File Name", each Text.BeforeDelimiter(_, "["), type text}})
in
#"Extracted Text Before Delimiter"