join two column

[pjacob]

I have a problem how join two tables, but unfortunately one tables have two column (one vlaue of them match) to another table

e.g.
table 1
value1 | value2
abc | bac
bac | abc

table 2
value
abc
abc

[izaychik63]

It is not clear what is you problem. If you want to join based on match of values in column 1 or 2.
Make cross join of the tables and then filter using Rule-based Row Filter necessary matches.

[pjacob]

@izaychik63 my common column in table1 has two column and one of them is correct . table2 have good value

[ipazin]

Hi there @pjacob,

not sure I understand but are you verifying table 1 (two columns) based on one column from table 2. If so what should be the output after verification? Also is verification row match based?

Br,
Ivan