Handling Null and space

[jkmpremaj]

Hi,

I have below table in Extract and handling nulls using mapping load.

Map_Null

Mapping LOAD

Null(),''

Autogenerate 1;

Map * using Map_Null;

Customer:

Load

Name,

Address,

DOB

from Customer.xlsx;

When I come to transfrom and do date transformation for DOB, again the space are getting converted to null.

Customer:

Load

Name,

Address,

Date(DOB,'MM/DD/YYYY') as Cust_DOB

from Customer.qvd;

Is there a way to keep space apart from using some if conditions like below?

if(DOB='',DOB,Date(DOB,'MM/DD/YYYY') ) as Cust_DOB

Also I don't want to use NULLASValue as the fields to be transformed are in large numbers.

[marcus_sommer]

You could try it with: alt(Date(DOB,'MM/DD/YYYY'), DOB)

- Marcus