Sign up to take part
Registered users can ask their own questions, contribute to discussions, and be part of the Community!
Added on May 20, 2024 5:04PM
Likes: 0
Replies: 1
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 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
A simple Join recipe will do this. Set the join to Contains.