IN-DB formula flag

[averyntxu]

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. 

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

[Thableaus]

Hi @averyntxu 

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

Cheers,

[averyntxu]

I'm using Oracle

[Thableaus · Accepted solution]

@averyntxu 

Try with Formula IN-DB tool

CASE WHEN UniqueID IS NULL THEN 1 ELSE 0 END

 Cheers,