Wildcard with In Function

[Chandrashekar]

Hello,

How to use wildcard with In Statment?

Column = if([state] In {"*action*"},"Action")

Regards,

Chandrashekar B

[Samarth_18]

Hi @Chandrashekar 

Please try like below:-

Column =
IF ( CONTAINSSTRING ( [state], "action" ), "Action" )

Thanks,

Samarth

[Chandrashekar]

Hello Samarth,

Is it possible with In function?

Regards,

Chandrashekar B

[Samarth_18 · Accepted solution]

@Chandrashekar I dont think so it possible with IN but we have certain other option as well like search or you can create in PQ using conditional column. In case you want to add multiple conditions then you can use below code:-

Column =
IF ( CONTAINSSTRING ( [state], "action" ) ||  CONTAINSSTRING ( [state], "condition1" ) || CONTAINSSTRING ( [state], "condition2" ), "Action" )

[Chandrashekar]

Thanks Samarth