Dynamic Input Tool Adding Worksheet name as a new column

[jeremy-appleyard]

Hi There, 

I am able to read all the data across multiple tabs from a single excel file and place into a single dataset. However i don't seem to be able to append the worksheet tab name as an extra column ?

Is this possible ?

I can get this to work when i am reading multiple files from a directory and adding them into a single dataset.

[Qiu]

@jeremy-appleyard 
Check this one and hope it will help.

https://community.alteryx.com/t5/Alteryx-Designer-Desktop-Discussions/Dynamic-Input-to-pull-from-ALL...

[binuacs]

@jeremy-appleyard Another method to extract the sheet name from the full path of the input file

[jeremy-appleyard]

Thanks, that worked a treat and easy to implement. Much appreciated.