Merge Duplicate Columns in Alterxy

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!

Alteryx Help.xlsx

Tips and Tricks

Best Practices

Accepted answers

ShankerV

Hi @syazana

Step 1: Input

Step 2:

Step 3:

Step 4:

(\u+)(\d)

Last step:

Many thanks

Shanker V

All comments

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

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!

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703