Solution for an Data Issue

[jpjust]

Hello All,

I have an table as below.

AppKey                            Customer

1009                                    Stell

1009                                     -

Following is the script.

LOAD
AppKey ,
Customer
FROM [lib://QVD_FOLDER/s/REST-APPS.QVD]
(qvd);

I want to exclude records that has null on Customer which I can easily achieve it by using where Not IsNull("Customer");

But I might have an record like below which I want to include even though the customer field is Null. How can I achieve this on the script?

AppKey                            Customer

1000                                      -

Thanks very much!!

[MarcoWedel]

what qualifies this record to be loaded?

[Saravanan_Desingh]

May be like this..

Where Not IsNull(AppKey&Customer)

[jpjust]

Thank you Saravanan. Unfortunately, that did not help in my situation.

I used the following.

LOAD
AppKey ,
maxstring(Customer) as Customer
FROM [lib://QVD_FOLDER/s/REST-APPS.QVD]
(qvd) group by AppKey;

And I tested, so far my dataset did not introduce any data issue.

Thanks