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...
hynguyen Thank you very much for your reply.
But I do not want to combine the other columns. I want to keep Quiz, Assignment, Test and Exam all in separate columns.
I would appreciate your help, please.
Thank you.
With merging of two queries, I guess FullOuter join to have all records from both, it's not clear where to add filenames - in one record it could be both name of first table file, as well as second one.