Join with "contains"

Hello,

I have looked for a fix to my question but I didn't manage to make any of the proposed solutions work.

The find-replace tool does not give me back what I need, and fuzzy match does not quite make the trick either.

My dataset has about 200k lines, so I would avoid solutions involving permutations.

This is the situation:

I have two tables, one with item numbers, one with the "family" they belong to.

I need to look for each item in Table A inside the families of Table B, and give back the first result where a contain match is verified:

Item Family example.GIF

Any suggestions?

Thank you!

Ilaria

Fuzzy Match

Join

Accepted answers

DavidP

Hi @Ilaria

How about this?

match items to first family.yxmd

All comments

DavidP

Hi @Ilaria

How about this?

match items to first family.yxmd

grazitti_sapna

Hi @Ilaria , is this what you are looking for?

I hope this will solve your problem.

Thanks.

joinwithcontains.yxmd

grossal

Hi @Ilaria,

I think you can do this with a little trick:

Steps:

- Record ID + Sort to reverse the order

- Copy the Family Column + remove all whitespaces

- Split with comma into Rows

- Find Replace on the single letters - it will match to the last object (that's why we reversed it) and append the Family

I'll attach the workflow for reference. Let me know if it works for you.

Best

Alex

2020-08-05-Join with contains.yxmd

rahul_Kumar_koshika

Hi @Ilaria,

I hope the workflow attached below will give the desired results as mentioned in your post.

Thanks.

Solution_for join.yxmd

kumaranvr1984

Hi llaria,

The below example seems like you can directly concatenate the items and match that with families.

But I think the real scenario is some thing different than your example. If so please provide some more details so that we can solve this.

Regards,

Kumaran

Ilaria

Hello @DavidP,

it worked perfectly! Smooth and fast execution too.

Thanks a lot!!
Ilaria

sgwong

Join Contains from 2 different Source.jpg

Source B for Coulmn B will contains huge word (10 to 200). If we split into multiple column, it will be created huge number row. Need your advice.

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15881

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703