Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
jpjust
Specialist
Specialist

Solution for an Data Issue

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!!

Labels (1)
3 Replies
MarcoWedel

what qualifies this record to be loaded?

Saravanan_Desingh

May be like this..

Where Not IsNull(AppKey&Customer)
jpjust
Specialist
Specialist
Author

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