- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
NullAsValue not working?
I have some very straightforward code that should work but simply doesn't:
NULLASVALUE *;
SET NullValue ='NA' ;LOAD
*
FROM
MyFile.qvd
(qvd);
The code executes without errors as shown in the script:
05/28/2013 11:20:51 AM: 0034 NULLASVALUE *
05/28/2013 11:20:51 AM: 0035 SET NullValue ='NA'
05/28/2013 11:20:51 AM: 0038 LOAD
05/28/2013 11:20:51 AM: 0039 *
05/28/2013 11:20:51 AM: 0058 FROM
05/28/2013 11:20:51 AM: 0059 MyFile.qvd
But it has no effect whatsoever if you look at the attached picture.
What am I doing wrong? I have exactly the same problem on two different computers, running QlikView 11.00 SR2 and 11.20 SR1.
Accepted Solutions
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Optimised QVD loads do not reprocess the data within the QVD row by row and
thus it will not apply the NullValue to the data. To get around this you must
force an unoptimised load of the QVD. You can add the WHERE clause to get around this
LOAD
*
FROM myfile.qvd (qvd)
WHERE 1=1;
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Optimised QVD loads do not reprocess the data within the QVD row by row and
thus it will not apply the NullValue to the data. To get around this you must
force an unoptimised load of the QVD. You can add the WHERE clause to get around this
LOAD
*
FROM myfile.qvd (qvd)
WHERE 1=1;
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi Use this
SET NULLDISPLAY= NA;
or SET NULLDISPLAY= 'NA';
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Thanks a ton! This was driving me crazy.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
GREAT DUDE