Important Community update: The process for changing your account details was updated on June 25th. Learn how this impacts your Community experience and the actions we suggest you take to secure your account here.

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Merge Duplicate Columns in Alterxy

syazana
7 - Meteor

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)

 

syazana_0-1681979726799.png

 

Thank you!

7 REPLIES 7
messi007
15 - Aurora
15 - Aurora

@syazana,

 

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

 

Regards,

 

ShankerV
17 - Castor

Hi @syazana 

 

One way of doing this.

 

ShankerV_0-1681980663898.png

 

 

Many thanks

Shanker V

syazana
7 - Meteor

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

ShankerV
17 - Castor

Hi @syazana 

 

Step 1: Input

 

ShankerV_0-1681980722132.png

 

 

Step 2: 

 

ShankerV_1-1681980737391.png

 

ShankerV_2-1681980748766.png

 

 

Step 3:

 

 

ShankerV_3-1681980770560.png

 

ShankerV_4-1681980781007.png

 

 

Step 4: 

 

ShankerV_5-1681980795658.png

 

(\u+)(\d)

 

ShankerV_6-1681980808625.png

 

Last step:

 

ShankerV_7-1681980835112.png

ShankerV_8-1681980844950.png

 

Many thanks

Shanker V

syazana
7 - Meteor

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

ShankerV
17 - Castor

Hi @syazana 

 

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

 

Have a pleasant day!!!!

syazana
7 - Meteor

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

Labels