nulls in ERD

[gidon500]

hi guys

I need to replace all null values in my ERD  as ZERO

enclosed in a sample of my documents  .

there are some NULL values that I want to replace

can it be done ?

thanks

gidon

[sunny_talwar · Accepted solution]

You can try this:

part:

LOAD * INLINE [

    part

    100

    200

    300

    400

];

vol1:

LOAD * INLINE [

    part, vol1

    100, 5

    200, 4

    400, 3

];

vol2:

LOAD * INLINE [

    part, vol2

    200, 13

    300, 15

];

Left Join (part) LOAD * Resident vol1 ; drop Table vol1 ;

Left Join (part) LOAD * Resident vol2 ; drop Table vol2 ;

NULLASVALUE *;

SET NullValue = 'ZERO';

FinalTable:

NoConcatenate

LOAD *

Resident part;

DROP Table part;

[gidon500]

Hi Sunny

thanks

gidon