mapping mess - clean up map * headache

Wed, 17 Apr 2013 14:10:12 GMT

Hi All,

I use the following code on a regular basis to change all blanks ('') to null values:

Map_Nulls:
Mapping Load
'',
null()
Autogenerate 1;
Map * using Map_Nulls;

I tried to adapt this code to change a few other values but have ended up in a bit of a mess!

In English, I need to do the following for ALL tables (about 20 of them) during the load process (i.e. I need to map *)

Field text Map

True 1

False 0

NULL null() *not the text, an actual null value

null() *text null() *not the text, an actual null value

I got into a mess originally because I thought I could replace the '' in my original code with 'NULL' but this didn't work, then I tried an inline load which only made it worse!

Can someone please tell me how to apply the mapping above to all fields on a table?

Thanks in advance!

GPC

topic mapping mess - clean up map * headache in QlikView

mapping mess - clean up map * headache