Forum Discussion
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...
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
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.