How can I filter by a list of values?

1

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
Fabian

2

Hi Fabian,

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

Regards,

Jochen

1 Like
3

I usually use

in([Location], 'GB,JPY',',')

1 Like