Change header names

[henrygeorge]

Hi Team,

So I have multiple Age column in my file  - so alteryx auto changed the name of the columns adding a 9_1 or a 9_2

This is fine. However at the end of my workflow I want all of these headers to change to Age

This is my final file -

Name	Age9_1	25042020	Age9_2	26042020	Age9_3	27042020	Age	28042020
Car	1	56	2	89	3	32	4	23
Bus	62	32	63	54	64	756	65	456

My output should be -

Name	Age	25042020	Age	26042020	Age	27042020	Age	28042020
Car	1	56	2	89	3	32	4	23
Bus	62	32	63	54	64	756	65	456

Please help

[Jonathan-Sherman · Accepted solution]

Hi @henrygeorge,

You can't have duplicate column headers in Alteryx, it simply isn't allowed. However...you could add an extra trailing whitespace on the end of "Age" to each duplicate column you wanted named "Age". To the eye you wouldn't see a difference.

If this solves your issue please mark the answer as correct, if not let me know! I've attached my workflow for you to download if needed.

Regards,

Jonathan

[DavidP · Accepted solution]

You can't have multiple columns with the same name in Alteryx, but you can do this:

[danilang]

Hi [at-mention author],

As a leader in the Alteryx Community, I have the ability to identify & mark accepted solutions on behalf of community members - and recently did so on this thread. If you have any questions or concerns with the solution(s) I selected please let me know by replying to this post.

As the original author, you also have the ability to mark replies as solutions! Going forward, I’d encourage you to identify the solution or solutions that helped you solve your problem, as it's a big help to other community members. Learn more about Accepted Solutions here.

I'v marked both of the answers given here as solutions.  @DavidP's answer is a good example of using the headers as the first row of data.  This coupled with an Output tool that Skips Field Names will give you a file with duplicate columns in the first row.  @Jonathan-Sherman demonstrates a creative, if unorthodox, solution to the problem as well.

Thank you!

Dan