Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
hkg_qlik
Contributor II

Loading

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

1 Solution

Accepted Solutions

Re: Loading

HI

Customer:

Load

Name,

Cust_ID,

Address

.

.

.

From

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

Hope it helps

1 Reply

Re: Loading

HI

Customer:

Load

Name,

Cust_ID,

Address

.

.

.

From

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

Hope it helps

Community Browser