How to create a dynamic contains function

Tags
Registered Posts: 29

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

filename sheet

filename.PNG

colors sheet

colors.PNG

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

Answers

Welcome!

It looks like you're new here. Sign in or register to get started.

Welcome!

It looks like you're new here. Sign in or register to get started.