Forum Discussion
Solved
power query add column with file name
hi, can someone help me : 1) adding the appropiate command so that i get in the final excel chart the filename for eacht line of data? 2) explaining why is this line used for "#"Invocar función...
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 helpful.
My excel version is 2016. So adding to the final chart the file name column is not available on the ribbon.
Can you help and tell me
how could I do it manually?
My excel version is 2016. So adding to the final chart the file name column is not available on the ribbon.
Can you help and tell me
how could I do it manually?
Sorry, I don't remember what s in 2016. Which of steps from previous you can't reproduce?