Join with contains

[Anastasio_Theohari]

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..

[mceleavey]

Hi @Anastasio_Theohari ,

The Find and Replace tool will give you exactly what you're looking for. I've joined the sets using this tool to tell me when one is a subset of the other. Then you simply filter out the ones that are not:

I've attached the workflow for you.

Hope this helps.

M.

[AngelosPachis · Accepted solution]

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