Forum Discussion
power query add column with file name
That's bit hard to do since I don't recognize names you use. If by steps:
Check generated master query which shall be in Other Queries
find Removed Other Columns1 step and click on gear.
Transform File column is always selected, select Source.Name and, if necessary, any other column(s) with file metadata. Click Ok.
Please note, Power Query could add this column automatically. Perhaps depends on version, not 100% sure.
If this is the case, could it be possible that I sent the Excel with the power query? How?
Thanks, juan
- Sorry for being so useless but I have tried it unsuccessfully. Could you help chaging what it has to be done in the above commands so that I copy paste in my power query editor?
That's bit hard to do since I don't recognize names you use. If by steps:
Check generated master query which shall be in Other Queries
find Removed Other Columns1 step and click on gear.
Transform File column is always selected, select Source.Name and, if necessary, any other column(s) with file metadata. Click Ok.
Please note, Power Query could add this column automatically. Perhaps depends on version, not 100% sure.
- Thank you so much for this!
