Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
gidon500
Creator II
Creator II

nulls in ERD

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

1 Solution

Accepted Solutions
sunny_talwar

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;

View solution in original post

2 Replies
sunny_talwar

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
Creator II
Creator II
Author

Hi Sunny

thanks

gidon