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
Solved! Go to Solution.
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,
I'm using Oracle