AYX TV Cooking Up Excel Outputs workflow

[Erin]

I have a fun blog going on over on LinkedIn geared towards learning Alteryx through stories. This last one was a bit more technical and I wanted to share my workflow. So here it is! Hope you all enjoy!

https://www.linkedin.com/pulse/cooking-up-excel-outputs-erin-miller-mba-tpdce 

[Carolyn]

Excel sheet names are picky eaters. No slashes, no colons, and keep it under 31 characters or the dish is rejected

---

I feel this! The other thing is that if you're doing a GDrive Input Tool, it can get upset if the Excel sheet name ends in a space (e.g. "Summary "). I think they fixed that bug, but it's also something to add to the picky/best practices list IMO.

I was using a formula to basically take the first x characters from a field and make that a sheet name, but I had to add a trim function

[Erin]

Agreed, the GDrive is definitely a picky eater! Thanks for adding that @Carolyn!