sql to visual recipe
mingyeong
Partner, Dataiku DSS Core Designer, Dataiku DSS ML Practitioner, Dataiku DSS Adv Designer, Registered Posts: 4 Partner
Hello.
I want to change sql -> visual recipe
but I don't know how to do.
Here, we have 2 tables.
table_1 has other columns and year
table_2 has other columns and year
select year not in
(
select year
from table_2
)
from table_1
How to change this sql to visual recipe
Best Answer
-
mingyeong Partner, Dataiku DSS Core Designer, Dataiku DSS ML Practitioner, Dataiku DSS Adv Designer, Registered Posts: 4 Partner
Thanks for replying.
I just want to use no-code method for conducting data mart.
After studying, I got the solution.
Use Join Recipe
pre filter : table_1.year is defined
join : Left
post filter : table_2.year is null
Answers
-
Miguel Angel Dataiker, Dataiku DSS Core Designer, Dataiku DSS ML Practitioner, Dataiku DSS Adv Designer, Registered Posts: 118 Dataiker
Hi,
A SQL query/scrip recipe is the best choice to handle this kind of database operations. What is your reasoning behind wanting to use a visual recipe instead?