Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Join with contains

Anastasio_Theohari
8 - Asteroid

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

2 REPLIES 2
mceleavey
17 - Castor
17 - Castor

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:

 

mceleavey_0-1618563762480.png

 

I've attached the workflow for you.

 

Hope this helps.

 

M.



Bulien

AngelosPachis
16 - Nebula

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.

 

AngelosPachis_0-1618563830849.png

 

You can configure the tool to only return you exact matches

AngelosPachis_1-1618563859693.png

 

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

 

Hope that helps,

 

Angelos

 

 

Labels