Discussion Feed
09-22-2020
08:16 AM
I have an ADQL that is trying to count the number of times a Customer is viewed. I have a data collector to add this data to Transactions. Here is the query: SELECT segments.userData.CustomerName, segments.userData.CustomerNumber, segments.userData.Agreement, count(segments.userData.CustomerName) FROM transactions WHERE application = "TruckCare-CustomerProfile" AND segments.userData.CustomerName IS NOT NULL But even with the WHERE clause 'CustomerName IS NOT NULL' There is still a line showing up with all nulls. I know there are Transactions that don't have CustomerName, CustomerNumber, or Agreement on them but I am expecting the 'IS NOT NULL' to filter those out. Any help much appreciated Thanks
... View more
- Tags:
- ADQL
Labels:
Latest Activity
- Kudoed Re: ADQL showing null rows even when IS NOT NULL is applied for Mario.Morelli. 09-22-2020 08:36 AM
- Posted ADQL showing null rows even when IS NOT NULL is applied on Business iQ (Analytics). 09-22-2020 08:16 AM
- Tagged ADQL showing null rows even when IS NOT NULL is applied on Business iQ (Analytics). 09-22-2020 08:16 AM
Community Stats
Date Registered | 09-22-2020 08:02 AM |
Date Last Visited | 12-02-2020 12:40 AM |
Total Messages Posted | 1 |