join two column

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

table 1
value1 | value2
abc | bac
bac | abc

table 2

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.

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

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?


This topic was automatically closed 182 days after the last reply. New replies are no longer allowed.