Easy IF/AND/OR expression question

[Carluccio555]

I'm still getting used to expression syntax in Alteryx and hoping someone can help.

I want column F2's value to be made equal to "Service" if the following condition is true:

[F2] = "Operations"

AND

The first character in [F4] = "5" OR The first 2 characters in [F4] = "H5"

Hope that's clear thanks!

[JosephSerpis · Accepted solution]

Hi @Carluccio555 I mocked up a example how to tackle this challenege. I would also recommed the Writing Condtional Statements Interactive lesson to get use to the syntax.

[gautiergodard]

Hey @Carluccio555 

A little hard to tell without sample data, however below is what I came up with. Hope this helps!

if [F2] = "Operations" and ((left([F4],1) = '5') or (StartsWith([F4], 'H5'))) then "Service"
else ''
endif