Forum Discussion

navafolk's avatar
navafolk
Helper IV
6 years ago

Add sheet name to folder query

Hi pros,

I am using query excel files from Folder.

It is good that Power Query automatically adds file name column to corresponding data, something like:

NameAccAmount
file1.xlsxacc11
file1.xlsxacc22
file2.xlsxacc12

 

Similarly, I would like to add sheet name column (which I chose at Navigation step) to corresponding data too, expected:

NameSheetAccAmount
file1.xlsx

sheet1

acc11
file1.xlsxsheet1acc22
file2.xlsxsheet1acc12

Furthermore, I wish sheet name added will be dynamic to my chosen at Navigation step which will not lost reference when I select another sheet at Navigation step. Please help!

Thanks a lot.

10 Replies