Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.

General Discussions

Discuss any topics that are not product-specific here.

If contain and doesn't contain logic

Shibasisnamdev
6 - Meteoroid

Shibasisnamdev_0-1666267700106.png

 

2 REPLIES 2
binuacs
21 - Polaris

@Shibasisnamdev 

 

If Contains([Task],'CH') Then 'ABC'
ElseIf Contains([Task],'BA') Then 'BAC'
ElseIf !Contains([Task], 'CH') And !Contains([Task], 'LO') Then 'DDD'
Else Null()
EndIf

 

binuacs_0-1666305093399.png

 

Shibasisnamdev
6 - Meteoroid

Thank you

Labels