I need to filter rows with more than 2 condition.
Currently I can filter with 1 keyword(Array) condition but I’m struggling with filter more 2 condition.
Below each columns has to meet each Array variable. (FYI. with 1 condition, it’s working properly)
Column"Description" → St_Arr_keyword
(From row In Dt2_HSBC_001.Asenumerable
Where St_Arr_keyword.AsEnumerable.Where(Function(x) row(“Description”).ToString.Trim.Contains(x.trim)).Count>0
but I need to meet additional condition more than 2. For example,
Column"In" → St_Arr_keyword2
Column"Out" → St_Arr_keyword3
could you please help for this logic?