How to join 2 datasets by looking up if a string in dataset A is contained in dataset B

[wonka1234]

Hi,

I have dataset A and B.

I want to lookup dataset A (Column X) into dataset B (column Y).

If dataset B(Col Y row) contains the string(not a full match, just if its exists in Col Y) from dataset A (column X) , then keep that row in dataset B.

Ie  Dataset A column X.

Does this exist in Databset B Col Y.

ie  

alteryxisacf2cool

alteryxs2pisawesome.

If it exists return dataset B rows which match this logic.

[Mchappell67 · Accepted solution]

Hi, @wonka1234 -

This is what I came up with:

Inputs:

Output:

Mark