
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
making NULL value into N
Hi,
I have a lot of NULL values in my table.
Is there any way I can make NULL into N?
Thank you!


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi David, maybe something like this:
NullMap:
MAPPING LOAD
'',
'N';
TABLE:
LOAD *
ApplyMap('NullMap', YourField)
FROM [YourPath]
Hope it helps,
Andrés


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi David, just a corrrection.
NullMap:
MAPPING
LOAD Map,
Con
FROM
[YourPath\NullTesting.xlsx]
(ooxml, embedded labels, table is Hoja2);
TABLE:
LOAD *
ApplyMap('NullMap', YourField,YourField)
FROM [YourPath]
And the mapping table works if you build something like this in for example an excel:
Map | Con |
N |
And then load it as I told you before in the NullMap.
Cheers,
Andrés

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
You can replace your expression in chart like below,
=If(IsNull(FieldName),'N', FieldName)

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi,
you can try =if(isnull(<fieldName>),'N',<fieldName>) if the field has a null value

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi david,
in your table if you have 'NULL'
try like this
if(yourfieldname='NULL','N',yourfieldname) as new
or
if you have blank like( )
try like this
if(len(yourfieldname)<1,'N',yourfieldname) as new1


- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
If you want to do it in Script Lever, Try this..
SET NullValue = 'N';
NullAsValue *; // You can give the listed field names instead of * (All fields)

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
u can replace in script as
set nullvalue='N';
nullasvalue*;
it will work

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
There are several ways of doing it. Please go through the below link which is having document attached

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
can u try tis?
