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

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

20200428 - ChangingColumnHeaders.yxmd