Forum Discussion

Junaid11's avatar
Junaid11
Helper V
4 years ago
Solved

Excel sheet name in a Column

Hello,

I have excel files with various sheets in them and I have put them in folder to import all the sheets of those excel files. I want a column name where I can see all the sheet names in each excel files. I am attaching pictures of my sheets and current imported folder  files as well. Kindly have a look at it and let me know about desired steps to make this work done.

Thank you

Imported Folder columns2nd excel sheets name1st excel sheets name

Need Help
  • hnguy71's avatar
    hnguy71
    4 years ago

    Hi Junaid11 , when you're transforming your sheets, within your helper queries, delete the Navigation step.

     

     

    Then you'll see the sheet and table names:

     

    Then you can click the combine binary icon.

     

     

1 Reply

  • hnguy71's avatar
    hnguy71
    Super User
    4 years ago

    Hi Junaid11 , when you're transforming your sheets, within your helper queries, delete the Navigation step.

     

     

    Then you'll see the sheet and table names:

     

    Then you can click the combine binary icon.