sql to visual recipe

mingyeong

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

mingyeong

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

Miguel Angel

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?