topic Solution for an Data Issue in App Development

Solution for an Data Issue

jpjust — Mon, 07 Mar 2022 18:35:23 GMT

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 — Mon, 07 Mar 2022 20:43:54 GMT

what qualifies this record to be loaded?

Saravanan_Desingh — Mon, 07 Mar 2022 22:40:12 GMT

May be like this..

Where Not IsNull(AppKey&Customer)

jpjust — Tue, 08 Mar 2022 17:47:30 GMT

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