Union Tool - when the other side is Null

Question

Hi,

Can someone help me on how to replace Null in the left side with a value in the right side after using the Union tool.

Like for example, if the cell on the right side has Currency value (GBP), and it will copy and replace the Null on the left side.

If both sides are null, then should be leave as it is.

Please see attached for your reference. Highlighted in yellow is the blank or null cell i want to have value with (GBP).

Thank you in advance.

After Union Tool.PNG

IraWatt · Accepted Answer

Hey @PassION_es,

Two options I'd recommend:

One rename your currency column to Ccy before the union so all the currencies end up in one column.

Or two use a formula like this:

IF [Ccy]=NULL() THEN [Currency] ELSE [Ccy] ENDIF

Any questions or issues please ask :)
HTH!
Ira

binu_acs · Accepted Answer

@PassION_es you can write the fomula like in the formula too

IIF([isEmpty(Ccy),[Currency],[Ccy])