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.
Thank you very much for the answer and explanation.
I have not deleted the file name column but when I get the data from the files and I cannot see in column with that file name.
What instructions should I use in order to get the file named into the final chart?
Thank you, Juan
Check you script. After Invoke Custom Function step script automatically adds Remove Other Columns. It removes all columns but Transform File one. Manually add Name column to the selection.