We are celebrating the 10-year anniversary of the Alteryx Community! Learn more and join in on the fun 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