sql to visual recipe

Options
mingyeong
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
    mingyeong Partner, Dataiku DSS Core Designer, Dataiku DSS ML Practitioner, Dataiku DSS Adv Designer, Registered Posts: 4 Partner
    Answer ✓
    Options

    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

Setup Info
    Tags
      Help me…