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
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:
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.