LIKE join
alexsee
Registered Posts: 1 ✭
How can I perform pattern matching similar to the SQL join with a LIKE operator in Dataiku as below:
SELECT
Data1 .*
Data2.NewName
FROM Data1 INNER JOIN Data2
ON Data1.Cust_Name LIKE CONCAT('%', Data2.Contains, '%')
Answers
-
tgb417 Dataiku DSS Core Designer, Dataiku DSS & SQL, Dataiku DSS ML Practitioner, Dataiku DSS Core Concepts, Neuron 2020, Neuron, Registered, Dataiku Frontrunner Awards 2021 Finalist, Neuron 2021, Neuron 2022, Frontrunner 2022 Finalist, Frontrunner 2022 Winner, Dataiku Frontrunner Awards 2021 Participant, Frontrunner 2022 Participant, Neuron 2023 Posts: 1,644 NeuronWelcome to the Dataiku Community.
Are you asking if we can do this with a visual recipe?
If so, I think you could do this with a Inner Join.
It appears that what you are trying to do is a case insensitive match. (This is typical of SQL Like). And you are trying to do a substring match (aka contains). Note my column names do not match your examples.
See if that is enough to get you going.
