IF statement with multiple condition

[faisal9999]

I want to translate this below code into alteryx can anybody help me out

WHEN platform NOT IN ('Amazon Display', 'FireTV') THEN

(CASE WHEN video_completion_25pct=0 THEN youtube_views ELSE video_completion_25pct)

WHEN platform='FireTV' THEN video_start ELSE 0

there are two condition which am not able to put in alteryx.

[FrederikE]

Hey @faisal9999,

This should do: 

IF [platform] NOT IN ('Amazon Display', 'FireTV')

THEN 

IF video_completion_25pct=0

THEN youtube_views

ELSE  video_completion_25pct

ENDIF

ELSEIF platform='FireTV'

THEN video_start

ELSE 0

ENDIF

[Raj]

try this

IF [platform] NOT IN ('Amazon Display', 'FireTV') THEN
IIF([video_completion_25pct]=0, [youtube_views], [video_completion_25pct])
ELSEIF [platform] = 'FireTV' THEN
[video_start]
ELSE
0
ENDIF

[faisal9999]

Thank you @Raj @FrederikE  both solution worked for me :)

[Raj]

Please mark it as solution !!
Have a great Weekend.