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

Question & Answer
,
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)

1 Like