Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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);
This was the solution for me:
SET NullInterpret = '';
Apparently it didn't read excels empty strings as Null