In case you missed the announcement: Alteryx One is here, and so is the Spring Release! Learn more about these new and exciting releases here!

Alteryx Designer Desktop Discussions

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

Specify sheet name in Dynamic Input for reading .xlsx file

srk0609
8 - Asteroid

I'm trying to bring top 3 Excel files based on date in file name. Each excel file has multiple sheets. There is sheet with name 'A' in all 3 excel files I want read data in sheet A of all 3 files but getting error 'No sheet specified, you must specify a sheet' in Dynamic Input. Can someone help?

srk0609_0-1670715313190.png

 

5 REPLIES 5
DataNath
17 - Castor
17 - Castor

Hey @srk0609, the [FullPath] field from the directory output stops at the filename and therefore doesn't contain the filename. Try making a new calculated field using the following expression, and feed that into the Dynamic Input instead:

 

[FullPath]+'|||'+'A'
Armon24
Alteryx
Alteryx

Hey @srk0609 !

 

Here is a sample workflow with the solution. Hope it helps. 

srk0609
8 - Asteroid

Thank you. I'll check and let  you know if it worked😊

 

srk0609
8 - Asteroid

Thank you. I'll check and let  you know if it worked😊

srk0609
8 - Asteroid

Thank you so much for the solution

Labels
Top Solution Authors