topic Handling Null and space in QlikView

Handling Null and space

jkmpremaj — Thu, 20 Sep 2018 14:18:42 GMT

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.

Re: Handling Null and space

marcus_sommer — Fri, 21 Sep 2018 10:36:22 GMT

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

- Marcus