Hi all,
I'm trying to find an efficient way of trying to find the count of records of the associated fields that have NULLs together.
My dataset is based on a certain number of Personal Traits; here is an example sample:
| LastName | Email | Address | Phone |
| Smith | smith@alteryx.com | 123 Somewhere St. | NULL |
| NULL | NULL | NULL | 555-555-5555 |
| Harambe | NULL | NULL | 123-333-3333 |
| NULL | NULL | 111 Sesame Place | 122-222-2222 |
| NULL | NULL | NULL | 111-222-3333 |
So what I want the output or results to show me is that:
| Field Combos | NULL_Counts |
| LastName/Email/Address | 2 |
| LastName/Email | 1 |
| Email/Address | 1 |
| Phone | 1 |
I want to get an idea which combo of fields has the most # of records with NULLs, and which combos may have likely to be NULL together.
Like just from observational purposes it seems like If LastName is NULL, Email is most likely NULL.
Thanks everyone for your help, lmk if you have any questions.
