Multiple columns with same name give warning every time

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.

How can I correct this?

Input

Dynamic Processing

Accepted answers

caltang

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.

All comments

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

Quick Links

This months top contributors

mceleavey 383

mbarone 337

Hollingsworth 335

LanisC 335

AdamR 335