Union Tool - when the other side is Null

[PassION_es]

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.

[IraWatt · Accepted solution]

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

[binuacs · Accepted solution]

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

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

[PassION_es]

thank you so much @binuacs  and @IraWatt for  the quick response.

I have a presentation later today and this error occurred suddenly on my output.

Case solved!

[IraWatt]

No worries @PassION_es ! glad it got sorted :)