This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
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?
Once you've brought the data together, you can use a formula like:
That might work well for this need.
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