Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.

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