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