Dynamic rename question - How to dynamically rename columns as F1, F2, F3 and so on?

Question

I used a select tool following file import so my first column is column F35. Following this, how do I rename the columns based on the remaining columns after the select tool, such that F35 (the first col) is now F1, F36 is F2, F37 is F3, and so on? I've tried dynamic rename, not sure if that works.

Thank you

martinding · Answer

If you know the column that you are selecting (for example, always F35) then it is simple.

Simply subtract 34 from all selected new columns using the Dynamic Rename Tool.

DataNath · Answer

@adriennelenker within Alteryx, we're not allowed duplicate field names. Therefore, we can use the following expression to make the first field 'F1' and then force an ascending numeric rename of subsequent fields (F2 onwards):

Rename fields to F1 onwards.yxmd

ShankerV · Answer

Hi @adriennelenker

Explaining with a use case below.

Full workflow:

Input 1:

After select tool:

Input tool 2:

After dynamic rename:

Output as you expected:

Many thanks

Shanker V