Use 2 fields from different tables in one filter

virus190 — Fri, 14 Jan 2022 12:57:01 GMT

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

Re: Use 2 fields from different tables in one filter

micheledenardi — Wed, 19 Jan 2022 22:27:04 GMT

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

topic Re: Use 2 fields from different tables in one filter in Connectivity & Data Prep

Use 2 fields from different tables in one filter

Re: Use 2 fields from different tables in one filter