changing null values in data load editor

[john_tremper]

Hi All,

I'm fairy new to QS data modeling.  I am wanting to change null values to spaces in the data load editor, rather than in the report.  I have scoured the interwebs and haven't found a solution to what I'm trying to do.  I'm hoping someone here will see my problem.  Thanks in advance for any help, tips, or encouragment that can be offered.

Here is what I have, I have posted all scripting below.  I have removed anything that didn't seem relevant for previty, so please let me know if you need to see the whole thing.  I am setting the nullasvalue and set null='null' in the main.  Further down I'm loading a table, then doing a reload to make sure the field I want to be blank has the value as 'null', then reloading the table again looking for value of 'null' and setting it to blanks (' ').  When I use that field in a report I am still getting 'null'.  Any ideas why?

From Main:

NullAsValue*;

SET nullvalue='null';

loading of the tables:

VendorMaster:

LOAD

     "Vendor Number.VNDVM00",

     "Vendor Number.VNDVM00" & ' - ' & "Vendor name.VNDVM00"

       as Vendor

FROM [lib://QDR-Common/VendorMasterFile_VNDVM00.qvd]

(qvd);

VendorMaster2:

NoConcatenate

load *

Resident VendorMaster;

Drop Table VendorMaster;

VendorMaster3:

NoConcatenate

load *,

If("Vendor Number.VNDVM00" = 'null', ' ', "Vendor Number.VNDVM00") as vnd#

Resident VendorMaster2;

Drop Table VendorMaster2;

and when i try to use vnd# in a report I still get 'null'

[PabloTrevisan]

Hi John,

Have you tried the mode:

If(IsNull("Vendor Number.VNDVM00"), '  ', "Vendor Number.VNDVM00") as vnd#

?

[balabhaskarqlik]

If("Vendor Number.VNDVM00" = 'null', ' ', "Vendor Number.VNDVM00") as vnd#

Above should work, may be try like this:

If(WildMatch("Vendor Number.VNDVM00", 'null'), ' ', "Vendor Number.VNDVM00") as vnd#

[john_tremper]

I did try this, and got the same results.  Should it be done prior to the reload?

[john_tremper]

This gave me the same results.  I am still seeing 'null' in the report.

I was hoping to not use the expression in the report, but instead in the data load.

[MK9885]

Maybe this?

If(Len(Trim("Vendor Number.VNDVM00")) = 0, '  ',"Vendor Number.VNDVM00")  as vnd#

[eduardo_dimperio]

Maybe you are not handle with a true Nothing and for that reason Isnull() does'nt work.

NULL – The Invisible Nothing

Finding NULL