Moving column values to another column

[Zona]

Hi community, I am struggling with moving column values to another existed column. [Right_Amount] is generated after a join tool, I know I can simply utilize a union tool instead to solve the problem. Unfortunately I need the left and right outer join's data. Thanks very much for anyone who will try to solve this. 

BR,

Zona

[binuacs]

@Zona one way of doing this with the tile tool

[AndrewDMerrill · Accepted solution]

Depending on which direction the problem needs to go in, here is an alternative solution although that is subject to change based on your requirements (i.e. I'm not sure what additional complexity the 'L' and 'R' outputs would add to this particular problem; more detail might elucidate).

[Zona]

@binucas

Thanks for for reply, I've learned another techique through your answer! And sorry for didn't make my words clear, I need the output to be like this.

[Zona]

@AndrewDMerrill It works perfectly for me! Thank you!