Alteryx Designer Discussions

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

Join us on Dec 2 for a half-day virtual analytics + data science event!
US & CA customers only

It's the most wonderful time of the year - Santalytics 2020 is here! This year, Santa's workshop needs the help of the Alteryx Community to help get back on track, so head over to the Group Hub for all the info to get started!

Include Excel Sheet name in output dataset using Dynamic Input tool

7 - Meteor

alteryx query.PNG



I need to read a directory with multipl eexcelsheets namesd ad per dates.I am trying to pick up and read all sheets within the excel with todays date in its name.


Example : I have 3 files named as Region_20190618 ,Region_20190619 ,Region_20190620 with multiple sheets.


I need to read todays excel all sheets.


The current way it reads my sheetname for the current date file instead of readin ghte file sheet contents.



Ok, makes sense.


You'd need to split the process into multiple steps.


Firstly, you will use the directory tool to load in details of all the files within the directory and use a filter to select the one with today's date.

Secondly, you will need to build out the full path to the file including the sheet names. If these are the same all the time, you can hard-code the logic however it'd be safer to use the approach you did


  • List all the sheets within the relevant work book
  • Also Full path to the file as part of the process



  • And then use another formula tool to replace the reference to <List of Sheet Names> in the full path with the individual sheet names



Replace([FileName], "<List of Sheet Names>", [Sheet Names])




Once ready, you can use another dynamic input to read each of the sheets within today's workbook.