Survey banner
The Dataiku Community is moving to a new home! We are temporary in read only mode: LEARN MORE

How to create a dynamic contains function

Level 3
How to create a dynamic contains function

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

desired output.PNG

is that possible to do in Dataiku?  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

Operating system used: windows

0 Kudos
1 Reply

A simple Join recipe will do this. Set the join to Contains.

Screenshot 2024-05-20 at 18.59.22.pngScreenshot 2024-05-20 at 18.59.39.png

0 Kudos


Labels (1)
A banner prompting to get Dataiku