how to get names of all sheets of a spreadsheet using Dynamic input tool

[Simi_M]

Hello,

I am trying to understand Dynamic Input tool. Is there a way by which I can get list of all sheets available in a spreadsheet using Dynamic tool. Also, my Dynamic tool is getting its path from Directory tool.

Regards,

Simi

[rituraj963]

@Simi_M

Refer this URL: https://community.alteryx.com/t5/Alteryx-Designer-Knowledge-Base/How-To-Import-Multiple-Excel-Sheets...

[JWS · Accepted solution]

@Simi_M you can add the <List of Sheet Names> with a formula tool. Please see the workflow attached.

[rituraj963]

@JWS your solution works 🙂

[Simi_M]

Hi , 

Is there a way that while fetching data from each tab I can have a sheet/tab identifier as well.

Regards,

Simi

[JWS]

@Simi_M here is a great post that dives into this topic. https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Import-multiple-Excel-Sheets-with-shee...

If you share your use case. I can provide some more specifics.

A pretty straight forward way is the following: Please see below a screenshot of the Dynamic input tool. You can Output the File Name as Field and then Parse the Sheet Name out of the Full Path.