Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
You could try it with: alt(Date(DOB,'MM/DD/YYYY'), DOB)
- Marcus