updating the members of a field based on the member of another field

[Bryth]

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? 

[geraldo]

@Bryth 

there has to be the else
if [sub...] == 11Try...' then 8 else [Visit...]
endif

the if construction is wrong

[Bryth]

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

[geraldo]

@Bryth 

if it's different from Day Off, what does it have to be?

[Yoshiro_Fujimori]

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.

[geraldo]

@Bryth 

you can use the switch:

formula example:

Switch([Sub Event Type], Null(),'Day Off',8, 'Day A', 1,'Day B',2)