Filter on Multiple Values

1

I am trying to use the Filter by Search function to filter on specific values in a Column. In the following screenshot, I am able to search on the term "Lithium" and generate results. However, I also want to include the term "Nickel" at the same time. How can this be accomplished?

Snag_afd9c1e
Snag_afd9c1e1029×346 83.1 KB

2

Try the action "Filter by condition" with

in([AttrValue],'Lithium-Nickel','-')

.

image
image766×542 12.9 KB

3

Yes, "Filter by condition" is an option here. The expression can be:

contains([AttrName], "Lithium") OR contains([AttrName], "Nickel")
1 Like
4

This worked. Thanks!

5

Thanks!

6

With your formula, both Lithium and Lithium Ion would be selected and I guess the intention was only to select Lithium and Nickel (without Lithium Ion).

image
image1135×811 31.3 KB

1 Like
7

If the intention was to have exact matches, then yes, you're correct.

In the initial post in the screenshot, the search mode is set to "Contains", so I assumed that was the intention. In any case, the author now has two solutions, one for each case. Thank you for contributing :slight_smile:

3 Likes
8

Is there a way to filter based off of terms that are listed in a separate reference file? For example if I have a list in a reference file that includes the terms "Lithium" and "Nickel" along with dozens of other terms?

9

Yes, there are a number of actions that can be helpful, depending on your case: