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.
Solved! Go to 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
No worries @PassION_es ! glad it got sorted :)