topic NULL value replacement in load in QlikView

NULL value replacement in load

Tue, 12 Jul 2011 11:20:05 GMT

Hi Everyone,

I have a really large dataset which has been exported from SQL server to a flat file. The Null values are assigned as 'NULL' ( a text string ). Is there a way I can replace all instances of NULL with a blank or a system missing?

Thanks

Gareth

NULL value replacement in load

kaushiknsolanki — Tue, 12 Jul 2011 11:26:33 GMT

Hi,

For replacing any string with other string, Replace(Text, From_Text, To_Text) function is used.

So in your case it will be

Load

Replace(Field1,'NULL','') as FIeld1

From xyz.

Regards,

Kaushik Solanki

NULL value replacement in load

Tue, 12 Jul 2011 12:15:07 GMT

So I have to go through every variable? This is a massive dataset. Is there no way to define what the missing value is? i.e. tell QV that for this document NULL = a null value?

NULL value replacement in load

Tue, 12 Jul 2011 15:42:09 GMT

Hello

You can replace all Nulls by putting this at the start of your load script.

It is very useful for debugging and data verification.

SET NULLDISPLAY = '#Null' ; //you can put anything in the quotes

Regards

Greenee

NULL value replacement in load

kaushiknsolanki — Tue, 12 Jul 2011 15:45:35 GMT

Hi,

This is not the variable its a field. And you need to say QV that search in this field for value NULL and replace it with ''.

Regards,

Kaushik Solanki

Re: NULL value replacement in load

Tue, 12 Jul 2011 15:47:16 GMT

Sorry I misread post.