Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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: