Hi @nicolas_mtam , you can’t use wildcards with the joiner nodes, so you’ll generally need to perform a Cross Join and then apply a Rule Based Row Filter with the required rules to match/filter each of the returned rows.
Alternatively you can achieve the stated output using my Join Custom Condition - indexed component:
Attach the first of your tables to the top, and the second table to the bottom. It uses SQL, so unfortunately your wildcards need to be adapted slightly to work, but you can configure the component as follows and it should do the job:
t2."Country" like replace(t1."Country",'*','%')
and t2."City" like replace(t1."City",'*','%')
and t2."Item" like replace(t1."Item",'*','%')
btw, Welcome to the KNIME Community! 