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!
Solved! Go to Solution.
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.
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?
When you export your workflow in Options -> Export workflow, make sure you include the macro in the package.