Excel Sheet name as an column output

[User]

Currently, on Alteryx, you can choose to "Output file name as field". I would like to output the file name and the sheet name as well. 

Can some please help. If possible, then how?

[john_miller9 · Accepted solution]

Hi @User

One way to do that would be to to select the "Full Path" option (which will include the sheet name) and then parse out the File Name and Sheet Name.

jm