community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

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

How to replace NULLs in a field with field values from a different stream?

Meteor

So I have two different streams in Alteryx, let's call them A and B:

 

Stream A has a field called [Cover], and some of the values in this field have NULLs or nothing in them. 

 

I want to make a condition where if the value in that field is indeed NULL or nothing (" "), then replace it with a certain value from stream B.

 

How can I do this?

Highlighted
Alteryx Certified Partner
Alteryx Certified Partner

Once you've brought the data together, you can use a formula like:

 

IIF(IsEmpty([FieldA]),[FieldB],[FieldA])

 

That might work well for this need.

 

Cheers,

 

Mark

Alteryx ACE & Top Community Contributor

Chaos reigns within. Repent, reflect and reboot. Order shall return.
Alteryx
Alteryx

@skyfire165 

 

First you'd want to do some sort of join to get the two streams together (join on a common ID, record position, etc) then can follow this with a formula tool.

 

Expression would look something like

 

       If IsNull([Cover]) then [Field_B] else [Cover] endif

Labels