Alteryx Designer Knowledge Base

Definitive answers from Designer experts.

Generating Excel Column Letters in Alteryx

12 - Quasar
12 - Quasar
Created

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.

Attachments
Comments
8 - Asteroid

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