Start Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Multi-Field formula Malformed If statement

Lichunhuang
7 - Meteor

 Hi, Can someone help me with my if statement below? thank you!

 

IF ISNULL([_CurrentField_])
THEN [_CurrentField_]

ELSEIF REGEX_Match([_CurrentField_],"[A-Z]*")

THEN "CONTAINS([" + tostring([Filter 1])+'],"' + tostring([_CurrentField_]) + '")'"

ELSE "aa"

ENDIF

 

 

11 REPLIES 11
Lichunhuang
7 - Meteor

Thank you! It works.

 

Thanks for everyone's effort!!

atcodedog05
22 - Nova
22 - Nova

Happy to help : ) @Lichunhuang 

Cheers and have a nice day!

Labels
Top Solution Authors