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?
