community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
SOLVED

Dynamic Input - List of Excel Sheet Names

Meteor

Hi there! I'm trying to get a list of sheet names for a sheet that I feed the filepath (eg C:\excel.xlsx) into a Dynamic Input tool. I receive a message saying "No sheet specified, you must specify a sheet". I don't know what the sheet names are, hence trying to get a list of sheet names. Is there a different configuration that I need to do for this?

 

 

 

2019-02-06_11-24-42.png

Highlighted
Alteryx Certified Partner

Hi @chanmar 

 

Try to add a Formula Tool before the Dynamic Input to your FilePath Field

Use this formula:

[FilePath] + "|||<List of Sheet Names>"

 

It should work.


Cheers,

Meteor

Worked like a charm, thank you!

Labels