Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

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

Change value in one column based on another column

Chirag_Gandhi07
8 - Asteroid

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.

2 REPLIES 2
Claje
14 - 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
Chirag_Gandhi07
8 - Asteroid

@Claje Thank you!!

Labels