Forum Discussion
Power Query: Get File Name
Hi guys, I am a teacher and I teach different subjects with different assessment types. I want to combine all the marks in a single spreadsheet and then process the grades in one go. I am struggli...
I found no duplications. When it could be
let
folder = "C:\Test",
Source = Folder.Files(folder),
RemoveUnused = Table.SelectColumns(Source,{"Content", "Name"}),
Addtables = Table.AddColumn(
RemoveUnused,
"Custom",
each Table.PromoteHeaders(Excel.Workbook([Content]){[Item="Sheet1",Kind="Sheet"]}[Data])
),
RemoveContent = Table.RemoveColumns(Addtables,{"Content"}),
ExpandContent = Table.ExpandTableColumn(
RemoveContent,
"Custom", {"Student ID", "Quiz", "Exam", "Assignment", "Test"},
{"Student ID", "Quiz", "Exam", "Assignment", "Test"}
)
in
ExpandContent