Hi,
I created a table using the queries method, I have a column "Name" of some elements and I would like to filter it by this column with different values to get the rows I need. When I do the first filter, it works it shows me the rows related with the first value. When I try to add a second filter with a second value, it shows me "There is no data to display" and I can understand that this is happening because of the filtering by the first value I put.
Is there a way to filter by different names/values to be able to get the rows I want?
I also tried by using a feed, I created a list with the elements I needed and used it to feed the filter but it replaced all the values on the column with the first name of the elements in the list instead filtering it.
Thanks in advance;
Regards.
Hi Gina,
If I am not mistaken this is expected behavior. The second filter will be based on the result of the first filter. For this case a possible workaround is using regular expression. In the below example, I would like to filter the rows that contains the process name SLDataMiner or SLNet:
The regular expression for this case will be:
\b(SLDataMiner|SLNet)\b
The result of the query will be:
Hope it helps.
Hi Miguel, if i want to filter the expression which contains New york which has a space in between them? which regex should i use.
Hi Ashwini,
I believe you could still use the same regular expression. For example:
b(New York|San Francisco)b
Thank you Miguel, that is what I needed !