Joiner node with wild cards

Hi KNIME community!

I’m trying to perform a one-to-many join using a “Joiner” module but with some wild cards.

My left table is specified with some values being “*” wild card to avoid any maintenance on the modalities of that dimension. I can change the value if necessary but I’m struggling to make my join.

I included a simplified example below with the expected output:

Table 1

| Country | City   | Item |
| Germany | Berlin | A    |
| Germany | *      | *    |
| *       | *      | A    |
| *       | Milano | *    |

Table 2

| Country     | City   | Item | Status | Quantity |
| Germany     | Berlin | A    | OK     | 2        |
| Switzerland | Zurich | B    | KO     | 3        |
| France      | Paris  | A    | OK     | 4        |
| Italy       | Milano | C    | KO     | 1        |
| Germany     | Berlin | A    | KO     | 5        |
| Switzerland | Basel  | C    | OK     | 3        |
| France      | Lyon   | D    | OK     | 4        |
| Italy       | Roma   | A    | OK     | 1        |

Table output

| t1.Country | t1.City | t1.Item | t2.Country | t2.City | t2.Item | t2.Status | t2.Quantity |
| Germany    | Berlin  | A       | Germany    | Berlin  | A       | OK        | 2           |
| Germany    | Berlin  | A       | Germany    | Berlin  | A       | KO        | 5           |
| Germany    | *       | *       | Germany    | Berlin  | A       | OK        | 2           |
| Germany    | *       | *       | Germany    | Berlin  | A       | KO        | 5           |
| *          | *       | A       | Germany    | Berlin  | A       | OK        | 2           |
| *          | *       | A       | France     | Paris   | A       | OK        | 4           |
| *          | *       | A       | Germany    | Berlin  | A       | KO        | 5           |
| *          | *       | A       | Italy      | Roma    | A       | OK        | 1           |
| *          | Milano  | *       | Italy      | Milano  | C       | KO        | 1           |

Any ideas how to achieve that?

Thanks,

Nicolas