NullAsValue not working

patrickbender — Sat, 28 Apr 2018 18:29:04 GMT

Hi I have the below code that i am trying to get the Null value to equal 0.

For some reason it is not working, could it be that i'm reading data from txt & xlsx files?

There is some more code (see attachment) but even if I only try this shorter example the Null values are still not changing.

Any ideas?

NULLASVALUE *;

SET NullValue = 0 ;

LOAD [FGLEDG_År],

[FGLEDG_Verifikat],

[FGLEDG_VerBeskr],

[FGLEDG_VerText],

[FGLEDG_Bokföringsdatum],

[FGLEDG_BokförtBelopp],

[FGLEDG_Konto] As Kontonr,

[FGLEDG_Ansvar] As Ansvarnr,

[FGLEDG_Projekt] As Projektnr

FROM [lib://CSVfiler/Huvudbok_BYG.csv]

(txt, utf8, embedded labels, delimiter is ',', msq);

[Projektnamn]:

LOAD [Kont beg] As Projektnr,

[Beskrivning]

FROM [lib://Byggsystem/QVS uppdelning.xlsx]

(ooxml, embedded labels, table is Projektnamn);

Re: NullAsValue not working

patrickbender — Sat, 28 Apr 2018 18:47:08 GMT

This was the solution for me:

SET NullInterpret = '';

Apparently it didn't read excels empty strings as Null