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 ex...
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.

     

     

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.