Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Wildcard XLSX Input - Problem with Space at end of Tab Name

nlarson002
6 - Meteoroid

Hello Alteryx Community,

 

Has anyone seen an update/workaround to Chaos Reigns Within's Wildcard XLSX Input error?  It appears that if you have a Tab Name that ends with a " " (space) then it will not be able to pull that tab into alteryx.  Attached is a very basic example.

 

Basically, the tool will pull in all of the tabs but Bananas and Kewis because in the tab name, there is an extra space.

 

Please let me know if you figure out a solution or update! 

 

As always, thanks in advance! 

3 REPLIES 3
DavidP
17 - Castor
17 - Castor

Open CReW_WildcardXLSXInput.yxmc and go to Formula (7) as in attached pic. Add +'$' after [Sheet Names] in the formula as shown below. Save the macro. It should now work in your workflow.

 

crewmacro.png

nlarson002
6 - Meteoroid

Thank you DavidP, this worked great! If I wanted to send a workflow to someone that is using this marco, is there a way to save this version of the macro? 

DavidP
17 - Castor
17 - Castor

When you export your workflow in Options -> Export workflow, make sure you include the macro in the package.

Labels