Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
Check out our powerful new search update! You can read more here. Please let us know if you have any feedback by creating a topic here.

Dynamically choosing a column

Meteor

I need to read the Opening Year for a store and then set the Opening Year Population equal to the column that contains that year's population.  I've attached a simple spreadsheet example to illustrate what I'm talking about

 

Thank you for any help

 

Buddy

Highlighted
Alteryx Certified Partner
Alteryx Certified Partner

Before reading the description, I thought my reply would include mention of the Dynamic Select tool. However, since you need a different column per record, my suggestion involves transposing the data first.

 

I've attached an example of how I would go about this problem. Another option would be to look into the Dynamic Formula tool available from the CReW tools.

 

http://www.chaosreignswithin.com/2013/11/dynamic-formula-macro.html

Labels