Multiple columns with same name give warning every time

[saachitalwar]

I have heading in the form

a	b	c	d	e	f
Summary	Summary	Summary	Summary	Summary	Summary

I want to keep the second row as the headers like 

Summary

Summary2

Summary3

Summary4

Summary5

Summary6

Right now alteryx is giving the warningin dynamic rename - 

Dynamic Rename (7) There were multiple fields named "Summary".  The duplicate was renamed.

Dynamic Rename (7) There were multiple fields named "Summary".  The duplicate was renamed.

How can I correct this?

[davidskaife]

Hi @saachitalwar 

The only way to correct it is to have the column names unique prior to ingestion into the Dynamic Rename tool, which is how they are ending up - Summary, Summary2 etc

The warning is there to inform you that you're trying to create columns with the same header, which Alteryx does not support

[saachitalwar]

so should put formula tool before dynamic rename and put " if [column] == "summary" then summary2 else [column]"

something like this or is there another way around it

[davidskaife]

The Dynamic Rename tool will automatically rename the columns for you into Summary, Summary2 etc. If you're happy with the warnings then you don't need to do anything!

[saachitalwar]

Ah ok, I just wanted to remove the warnings as well

[caltang · Accepted solution]

You could pivot the names or use the field info tool plus record ID and tile tool to name and sort the header names, then dynamic rename them. The headers will follow that naming convention and will remove the warnings for you.