How can I filter by a list of values?

Hello, sorry because Im just getting started with EasyMorph and maybe its a very basic question but I would like to filter by condition by applying a list of values. I found this can be made this way:

[Location] = ‘GB’ or [Location] = ‘JPY’

but my list is big and I dont want to specify for each of the values which column Im referring to, just select one column and provide a list of values for selecting all the rows matching the values of the list.

Thank you in advance

Hi Fabian,

you can use the keep/remove matching action for this.



1 Like

I usually use

in([Location], ‘GB,JPY’,‘,’)

1 Like