Forum Discussion

Alpesh's avatar
Alpesh
Helper I
2 years ago

Search for multiple text values (with OR condition)

Is there a way to search for more than two text values with an OR condition? Dataset is >10GB and we are using star schema with mutliple dim tables. The Condition needs to be applied to a comment (ve...
Need Help
Uzi2019's avatar
Uzi2019
Community Champion
2 years ago

Hi Alpesh 
If user want to search for a keyword then you can use Text filter visual from App source.

But unfortunately It nly accepts single column. You can concatenate the 2 columns and use in search filter visual.

 

Or you can add search functionality in a slicer ( by clicking on 3 dots on top right corner of slicer). where you can add multiple columns as a hierarchy in single slicer. 

 

If my post helps then give kudos and accept it as a solution!
Thanks

 

Alpesh's avatar
Alpesh
Helper I
2 years ago

hi, thanks but the search needs to be in 1 column. For example, we take all comments on social media. and if we want to get all comments on Man Utd we would need to filter for all the following words in the comment:
ManUtd OR Manchester United OR ManU OR MUFC OR Man United
That's a fake example, but hopefully you understand more the context

  • Uzi2019's avatar
    Uzi2019
    Community Champion
    2 years ago

    hi Alpesh 
    if the comments column has exact this value then only Man will search the following data
    ManUtd 

    Manchester United 

    ManU 

    MUFC

    Man United

     

    if you search MUFA then only MUFA will apear.

     if you want result of all values by  searching only Man Utd then you have to mapped all the respected values.