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

Alteryx designer Discussions

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

The highly anticipated Alteryx Community tradition is back! We hope you'll join us!

Learn More
We will be upgrading the Gallery to our 2019.4 release this Saturday, December 7th beginning at 9:00am MT. We expect the outage to take last approx. 2.5 hours.
SOLVED

Include Excel Sheet name in output dataset using Dynamic Input tool

Meteoroid

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.

 

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