Discover all of the brand-new features and improvements to existing capabilities in the Dataiku 11.3 updateLET'S GO

sql to visual recipe

Solved!
mingyeong
Level 2
sql to visual recipe

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

 

0 Kudos
1 Solution
mingyeong
Level 2
Author

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

View solution in original post

0 Kudos
2 Replies
MiguelangelC
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?

mingyeong
Level 2
Author

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

0 Kudos