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

[csun1994]

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

[csun1994]

I want to add, not manually through the select tool, there needs to be a way that the column that starts on F35 is immediately changed to F1, and so on, so that F35-F40 in the unchanged dataset is now F1-F6 after being renamed.

[ShankerV]

Hi @csun1994 

Yes, it will work if you link it with the field names in another input.

Many thanks

Shanker V

[markcurry]

Hi @csun1994 ,  hopefully the attached workflow will help.

[ShankerV]

Hi @csun1994 

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

[DataNath]

@csun1994 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):

[martinding]

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.