NULL value replacement in load

[#1]

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

[kaushiknsolanki]

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

[#3]

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?

[#4]

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

[kaushiknsolanki]

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

[#6]

Sorry I misread post.