In case you missed the announcement: The Alteryx One Fall Release is here! Learn more about the new features and capabilities here
ACT NOW: The Alteryx team will be retiring support for Community account recovery and Community email-change requests Early 2026. Make sure to check your account preferences in my.alteryx.com to make sure you have filled out your security questions. Learn more here
Start Free Trial

Alteryx Designer Desktop Discussions

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

Replacing multiple columns that have the same name

srea541
8 - Asteroid

I have multiple columns that need to be replaced with another column with the same name - one such example is below:

 

I want to replace this column from source one:

srea541_1-1654532597575.png

 

 

with this column from source two: 

srea541_2-1654532703906.png

I know i could do this for one change using the formula tool and just making the 1st one equal the 2nd one, but how would I do the above for multiple columns without having to write alot of formulas?

 

Im currently using a join but this adds "right_" to the 2nd column and I would have to manually reposition them as well.

 

Thanks!

 

10 REPLIES 10
Ladarthure
14 - Magnetar
14 - Magnetar

Hi @srea541,

 

please find attached the workflow with the solution I described yesterday

Labels
Top Solution Authors