IN-DB formula flag

First time using In-Database tools.

I'm trying to use only In-DB tools to make this as efficient as possible but this is essentially what I want to do.

2019-04-23 13_51_23-Window.png

I know I need to use an outer join but I can't get the SQL expression correct to flag if the Left attached table unique id is Null.

This is essentially the formula I would use:IF IsNull([Unique ID])THEN 1 ELSE 0 ENDIF

Join

In Database

In-Database

Accepted answers

Try with Formula IN-DB tool

CASE WHEN UniqueID IS NULL THEN 1 ELSE 0 END

Cheers,

Which database provider are you using? That's really important since Formula In-DB tool depends on the syntax of the database.

Cheers,

I'm using Oracle