Desktop productivity for business analysts and programmers

Using contains by select multiple values

Reply
Frequent Contributor
Posts: 83

Using contains by select multiple values

I have a data column (Exceptions) that has concatenated values.

EXAMPLE

Exceptions

MP, EO

LO

LO,TS

LI

LI,TS,TE

I have created a prompt using the prompt manager.  I want to be able to select "multiple values" from the Exceptions column.

However,  I am unsure how to be able to select multiple values by using the operator "contains."

For example,  if I use operator contains and select LO from a list it returns values: LO or LO,TS.  If I wanted to select both LO and EO; I get an error because contains only works with a single value.

Any help with this would be appreciated.


Ask a Question
Discussion stats
  • 0 replies
  • 417 views
  • 0 likes
  • 1 in conversation