The Product Idea boards have gotten an update to better integrate them within our Product team's idea cycle! However this update does have a few unique behaviors, if you have any questions about them check out our FAQ.

Alteryx Designer Desktop Ideas

Share your Designer Desktop product ideas - we're listening!
Submitting an Idea?

Be sure to review our Idea Submission Guidelines for more information!

Submission Guidelines

Fieldnumber function in Dynamic Rename tool

Hi all,

 

Hope you are doing well! Recently I have come across a use case where I had to dynamically rename columns based on Field name ánd position. While I was able to come to a solution using a set of tools, it got me thinking: would it be possible to include the Fieldnumber function exactly like already has been done in the dynamic select tool (i.e. 'Select via a Formula - Column Position' example)?

 

For example, one would write: IF ([FieldNumber] = 1) OR ([FieldNumber] = 3) OR ([FieldNumber] = 7) THEN [_CurrentField_]+"_Code" ELSE  [_CurrentField_] ENDIF