Calculate a column of true/false based on multi-value parameter

Q&A
, ,
1

Hi,
I’m looking for a function a which checks if a string column c1 contains substrings apeearing in a multi-value parameter p2. For example if my p2 parameter contanis 2 values, ‘amreica’ and ‘ball’ and my c1 column contains 4 values of ‘amreica x’, ‘sky ball’, ‘basket ball’ and ‘f-side’, only rows with ‘amreica x’, ‘sky ball’, ‘basket ball’ values will get true. ‘f-side’ will get false.
Any ideas?

2

Hi @amico

See if the following post helps you. Basically you have to use the IN function for your search and also include a case where the Select All is selected in the parameter (see the note from @ErikG in the post)

3

Hi @amico,
It’s been awhile since we last heard from you on this thread, did you have any additional questions regarding your initial post?

If we do not hear back within the next 3 business days, I’ll close out this topic.

Thank you!

4

Hi @amico,
Since we have not heard back, I’ll go ahead and close out this topic. However, if you have any additional questions, feel free to create a new post in the community and link this discussion for relevant information if needed.

Thank you