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

Alteryx designer Discussions

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

Looks aren't everything... But the latest Community refresh looks darn good!

Learn More
SOLVED

Change value in one column based on another column

Hello everyone,

I have a column that contains the values yes or no (Q4). I have another column that contains values in certain rows (Unselected Software). I want it so that if a row contains a value for Unselected Software, the value in Q4 should be changed from yes to a no.

Magnetar
Magnetar

Hi,


You can do this with a formula on your Q4 Column.


Here's an example

 

IF !ISEMPTY([Unselected Software]) THEN 'No' Else [Q4] ENDIF

@Claje Thank you!!

Labels