Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hey,
I wanna know If there I could put a value defect insted of NULL when I use Outer Join Sentense.
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
Dario
The NullAsValue load script statement may be of use to you.
Best Regards, Bill