Use 2 fields from different tables in one filter

[virus190]

hi,

i have 2 different tables:

Example:

Table1:

ID	Name
1	Name1
2	Name1
3	Name2
4	Name2
5	Name3

Table2:

ID	Name
1	Name3
1	Name2
3	Name3

I want to have one filter where i search the name from table1 or table 2.

I've seen solutions but only with the data load editor, which we dont want to use if possible, because we are using the data manager 😕
Is there any way to do it in the frontend?

In sql it would be a simple ... where Table1.Name = X or Table2.Name = X

[micheledenardi]

No ways to do that in one single Filter pane without passing by load script.

You can do that via operators in Set Analysis:

In case check these two articles:

Set analysis 

Set operators