Moving column values to another column

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

螢幕擷取畫面 2024-07-29 152307.png

螢幕擷取畫面 2024-07-29 152117.png

Preparation

Accepted answers

CoG

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).