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

Alteryx designer Discussions

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

Change value in one column based on another column

Highlighted

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