Merge Duplicate Columns in Alterxy
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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!
Solved! Go to Solution.
- Labels:
- Best Practices
- Tips and Tricks
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi @messi007 , I added an Excel file :) Thanks!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Wow @ShankerV that was fast!! Let me try this! Thank you so much
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi @syazana
Happy to help!!!!. Let me know if you have more questions if any.
Have a pleasant day!!!!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi @ShankerV, I've tried using your solution & it works for me! Thanks!
