Start Free Trial

Alteryx Designer Desktop Discussions

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

if statement that applies to multiple columns

himam
6 - Meteoroid

Hi guys I am transfering over from SAS to Alteryx and trying to replicate a procedure. I have three columns which already exist and If the first column has a certain value I want to input values in the other two columns. I understand I can use the formula tool function but then I would have to repeat the procedure with both columns and was wondering if there is a less tedious way of doing this. 

 

Right now I have two entries in the formula tool as shown below, I would like to combine it into one formula

himam_0-1674151913256.png

 

1 REPLY 1
DataNath
17 - Castor
17 - Castor

Hey @himam, if you were really determined to keep things to a single tool/formula then you could look into going down a route like this:

 

DataNath_0-1674152484650.png

 

However, I think it's a lot easier and more intuitive to just do it using your current approach, updating each field at a time.

Labels
Top Solution Authors