Merge Duplicate Columns in Alterxy

[syazana]

Hi, 

Alterxy will automatically rename my columns if they have the same name.

Warning: Dynamic Rename (169): There were multiple fields named "CURRENCY". The duplicate was renamed.

How do I merge the column with the same name instead of having Alteryx renaming them by adding numbers at the end?

My input is dynamic, as in I will have different number of duplicates each run, i.e.; this month I could have up to 3 duplicate columns (hence CURRENCY3 & ITEM3) but next month I could have more (eg. up to CURRENCY8 & ITEM8)

Thank you!

[messi007]

@syazana,

Could you share a sample data instead of a screen shot?

Regards,

[ShankerV]

Hi @syazana 

One way of doing this.

Many thanks

Shanker V

[syazana]

Hi @messi007 , I added an Excel file :) Thanks!

[ShankerV · Accepted solution]

Hi @syazana 

Step 1: Input

Step 2: 

Step 3:

Step 4: 

(\u+)(\d)

Last step:

Many thanks

Shanker V

[syazana]

Wow @ShankerV that was fast!! Let me try this! Thank you so much

[ShankerV]

Hi @syazana 

Happy to help!!!!. Let me know if you have more questions if any.

Have a pleasant day!!!!

[syazana]

Hi @ShankerV, I've tried using your solution & it works for me! Thanks!