Hello team,
I need help with this in Alteryx. I have to update the duration Field to be 8 if the sub event type is Day off. I have tried this If logic but I I dont want to include Elseif/ Is there a way to go around this in Alteryx?
there has to be the else
if [sub...] == 11Try...' then 8 else [Visit...]
endif
the if construction is wrong
It outputs 0 for all the day off when I use the Visit duration before the endif
IF [Sub Event Type]="Day Off" THEN [Visit Duration] = '8' Else [Visit Duration] ENDIF
Hi @Bryth ,
Your Formula configuration shows [Visit Duration] in the expression.
If you want to update [Visit Duration] column, you should specify it in "Output Column" as below.
The reason why it outputs "0" for all the day off is that the expression [Visit Duration] = "8" is false (= 0).
I hope this helps.