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.
Hi @messi007 , I added an Excel file :) Thanks!
Wow @ShankerV that was fast!! Let me try this! Thank you so much
Hi @syazana
Happy to help!!!!. Let me know if you have more questions if any.
Have a pleasant day!!!!
Hi @ShankerV, I've tried using your solution & it works for me! Thanks!