Outer Join With a default value insted of NULL

[coddra_6]

Hey,

I wanna know If there I could put a value defect insted of NULL when I use Outer Join Sentense.

[marcus_malinow]

Hi Dario,

You could try something like this

MainTable:
LOAD ......

LEFT JOIN (MainTable)
LOAD ... [from your join table]

MainTable2:
LOAD *,
if (isnull(joinedvalue),defaltvalue, joinedvalue) as Value
RESIDENT MainTable;

Alternatively, if your tables have a one to one relationship, an ApplyMap allows you to specify a default value.

Marcus

[Anonymous]

Dario

The NullAsValue load script statement may be of use to you.

Best Regards,     Bill