Loading

[hkg_qlik]

Hi,

I want to load records from a table when a particular field is empty/null/no value.

I have a qvd file which is a source for this load.

Customer:

Load

Name,

Cust_ID,

Address

.

.

.

From

Customer.qvd(qvd);

I want to load only those records with CustID is null/blank?

Regards,

H

[MayilVahanan · Accepted solution]

HI

Customer:

Load

Name,

Cust_ID,

Address

.

.

.

From

Customer.qvd(qvd) where Len(Trim(Cust_ID)) = 0;

Hope it helps