6/17/21: We have completed maintenance for the Search functionality on the Community. If you are seeing any issues, please try to clear your cache first. If the issue persists please email Community@alteryx.com

Alteryx Designer Knowledge Base

Definitive answers from Designer experts.

Generating Excel Column Letters in Alteryx

12 - Quasar

This article was inspired by the Idea posted here


The attached macro will use the Field Info Tool and a formula to calculate the Excel column letter, e.g., for 755th field, the returned letters would be "ACA".


The attached workflow is a test to generate some number of fields.


The macro also has the ability to return sample data so you can see some sample contents as well.


column letter.png

Attached in the v 10.5 assets Column Letter.yxmc and example use of Column Letter.yxmd.

8 - Asteroid

This is interesting! And I learnt a new tool - Generate Row today! Thank you for sharing!