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

Include Excel Sheet name in output dataset using Dynamic Input tool

alteryx query.PNG

@MichalM 

 

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.

 

Highlighted
Alteryx
Alteryx

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

full-path.png

 

  • 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.

 

formula-full-path.png

Labels