Alteryx Designer Discussions

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

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

SAVE YOUR SPOT
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!

Replace sheet name using the action tool

Highlighted
6 - Meteoroid

Hi,

 

I was wondering if there's anyway to have the action tool to replace the sheet name of the input?

 

In the workbook I would have different sheets such as Apple 2019, Orange 2019 and etc. I would always want to pull the sheet that contains "Apple*" in the name so when the user select the excel, it will automatically pull the sheet containing Apple.

 

Thanks!

 

 

 

Highlighted
Alteryx Certified Partner
Alteryx Certified Partner

Are you developing an application to host on the gallery? If so this won't be possible.

 

If it's an application/macro that will sit on the users machine, then it is possible.

 

Ben

Highlighted
6 - Meteoroid

Hi Ben,

 

It will not be host on the gallery, the user will have this application on their desktop.

 

Thanks!

Highlighted
7 - Meteor

Any solution to this issue? I'm trying to do the same thing!

Labels