Join with "contains"

[Ilaria]

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:

Any suggestions?

Thank you!

Ilaria

[DavidP · Accepted solution]

Hi @Ilaria 

How about this?

[grazitti_sapna]

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

I hope this will solve your problem.

Thanks.

Thanks.

[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

[rahul_Kumar_koshika]

Hi @Ilaria,

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

Thanks.

[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]

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.