Join with contains

Question

Hello guys,

Please for your help..

I have two tables...

TableA

Product No.      Description

001                     A

0007                   B

014                     C

TableB

ProductDetNo.      Description

001-241               A

004                      N

0007-9                 B

0145-972             Z

The final table with a join between the above two tables,i would like to be :

TableC

Product No.   ProductDetNo   Description

001                     001-241             A

0007                   0007-9               B

So the join is something like Product No contains ProductDetNo..

Thank you for your help..

AngelosPachis · Accepted Answer

Hi @Anastasio_Theohari ,

You can do that using a Find & Replace tool, looking for values contained in Table A Product No. column in the Table B Poduct Det No. column.

You can configure the tool to only return you exact matches

so 014 will not match with 0145 but 0007-9 will match with 0007.

Hope that helps,

Angelos