Sign up to take part
Registered users can ask their own questions, contribute to discussions, and be part of the Community!
Registered users can ask their own questions, contribute to discussions, and be part of the Community!
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
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
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?
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