Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
Check out our powerful new search update! You can read more here. Please let us know if you have any feedback by creating a topic here.

Import xls with 2 different Sheets

Highlighted
Meteoroid

Good Morning,

 

I am trying to import an xls file with 2 different sheet names. This data always comes as an xls and is not able to be converted to an xlsx.

 

What is the best way to do this? I know the dynamic input tool can be used for xlsx, but not sure how to bring both sheets in with an xls file.

 

Thanks!

Highlighted
Alteryx
Alteryx

Hey @NRD,

 

I would recommend looking into a macro posted in the link below. It should get you what you want!

 

https://community.alteryx.com/t5/Engine-Works-Blog/The-Ultimate-Alteryx-Holiday-gift-of-2015-Read-Al...

 

Let me know if you have any questions. 

 

Nick

Labels