Forum Discussion
skhemka
May 31, 2020Copper Contributor
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...
skhemka
Jun 08, 2020Copper Contributor
SergeiBaklan Thank you very much for your help here. I am a novice Power Query user and couldn't work out what you have proposed here. Instead, I found a solution that works for me. I added a new column using the index (custom) function (with 0 increments) and then added the code name as a prefix.
SergeiBaklan
Jun 08, 2020Diamond Contributor
I see, thank you for the update. By the way, Index with zero increment that's just a constant, e.g. number 1. If so, you may add custom column in one step as ="Code1" or so.