Mass renaming of Headers based on previous header names

[BenjaminLaudereau]

Hello,

I have a file on which I need to rename a high number of headers (+ 2000 headers).

The Input header names is as below (I've also attached it in case it is too small)

 

On the screenshot, I would need to rename headers F13 to F19 with "Lucie BACON" and header F21 to F27 with "Pierre ULLRICH" and so on for 2000 headers. I looked at the dynamic rename tool but I have not idea if I can use a formula to do that and what the formula would be.

Could you please help me on this.

Many thanks in advance for your help 🙂

Benjamin

[AngelosPachis]

Hi @BenjaminLaudereau ,

Unfortunately Alteryx won't allow you to have the same column header for multiple headers. So there's no way you can have columns F13 to F19 renamed as "Lucie Bacon", as the extra columns will be automatically renamed to "Lucie Bacon2", "Lucie Bacon3" and so on.

What's the use case for this? Maybe the answer to your question lies in creating a table using the reporting tools