Renaming Headers Inconsistency

[SaraChen25]

Hello,

My headers are repeated but the way Alteryx renames it is weird. For example, I would expect P1 to be renamed as P1_2, P2 to be renamed as P2_2, etc. However, P2_2 is renamed to P9_2. Does anyone know why?

[dwstada]

interesting bug, in my recreation alteryx tried to continue the sequence (2023.1)

no idea why it does that, but it seems like you have to fix that before inputting or work based on column positions

[KenL]

This behavior when automatically renaming duplicate field names that end with a number is expected, see the Help documentation for more information.

You can also use the Dynamic Rename tool to rename the fields as you like.

[Yoshiro_Fujimori]

Hi @SaraChen25 

As suggested by @KenL , if you use Dynamic Rename tool, the workflow may be like the attached workflow.

I hope this helps.

Workflow

[Yoshiro_Fujimori]

Forgot to attach the input data. Re-attach the same workflow in yxzp format.