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

If statement where when the conditions don't apply then leave the original values

himam
6 - Meteoroid

Hey guys can anyone check my formula and help me figure out what is wrong with it? What I want is to change the value in variable SECTIONNAME if it meets the following condition, else leave it as it was. Instead it takes many values for the variable SECTIONNAME and changes them to 0 :/ 

 

IF [POLICY_YEAR]<=2016 and [GREATPLAINSCODE]="755"

THEN [SECTIONNAME]="WKA"

ELSE [SECTIONNAME]

ENDIF

1 REPLY 1
Felipe_Ribeir0
16 - Nebula

Hi @himam 

 

Try

 

IF [POLICY_YEAR]<=2016 and [GREATPLAINSCODE]="755"
THEN "WKA"
ELSE [SECTIONNAME]
ENDIF

 

Felipe_Ribeir0_1-1674337010279.png

 

 

Labels