How to create a dynamic contains function

[AbdulBalogun]

I have 2 files / sheets, one that shows file names and one that shows colors 

filename sheet

colors sheet

what I'm trying to do is somehow link these two datasets, if filename contains one of the colors in my colors sheet, then in a new column list that color.

desired output

is that possible to do in Alteryx, I thought about unioning the 2 sheets then doing s contains function but that didn't work for me

I've attached the sample excel with 2 sheets

[binuacs · Accepted solution]

@AbdulBalogun use the find and replace tool