Alteryx Designer Desktop Discussions

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

What formula/workflow can I use to dynamically adjust the range that my output writes to?

AkisM
10 - Fireball

My input data will always result in different numbers of columns and rows being output. For rows I know how to simply use a counter and then have my output tool configured to read the exact output location+range from a field. But for columns (number of fields), how do I make my output range dynamically change?

It should follow the typical excel sheet naming convention where column 1 corresponds to A, column 2 B, etc, until it cycles back to AA, AB, AC etc.

 

A sample workflow would be much appreciated.

0 REPLIES 0
Labels