Early bird tickets for Inspire 2023 are now available! Discounted pricing closes on January 31st. Save your spot!

Alteryx Designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer and Intelligence Suite.
SOLVED

Union Tool - when the other side is Null

PassION_es
9 - Comet

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.

 

 

 

4 REPLIES 4
IraWatt
17 - Castor

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

IraWatt_1-1653664097477.png

 

 

Any questions or issues please ask :)
HTH!
Ira

binuacs
17 - Castor

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

 

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

PassION_es
9 - Comet

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
17 - Castor

No worries @PassION_es ! glad it got sorted :) 

Labels