Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hello,
How to use wildcard with In Statment?
Solved! Go to 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" )
Best Regards,
Samarth
If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudos!!
Connect on Linkedin
Please try like below:-
Column =
IF ( CONTAINSSTRING ( [state], "action" ), "Action" )
Thanks,
Samarth
Best Regards,
Samarth
If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudos!!
Connect on Linkedin
Hello Samarth,
Is it possible with In function?
Regards,
Chandrashekar B
@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" )
Best Regards,
Samarth
If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudos!!
Connect on Linkedin
Thanks Samarth
User | Count |
---|---|
60 | |
22 | |
18 | |
18 | |
16 |
User | Count |
---|---|
86 | |
54 | |
54 | |
38 | |
21 |