topic Re: nulls in ERD in QlikView

nulls in ERD

gidon500 — Thu, 13 Oct 2016 14:23:54 GMT

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 — Thu, 13 Oct 2016 14:26:41 GMT

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 — Thu, 13 Oct 2016 15:09:50 GMT

Hi Sunny

thanks

gidon