Hi Team,
Requirement is:-
*There is a table that contains 50 or 50+ Columns
* Within that, there are multiple columns that are Null with a certain percentage. For instance, column City is having null values in 35% records
* So we need to have segregation of such Null records for other columns. For instance, for above 35% records, I want to see breakdown with other columns like Country, Region, State etc.
* One example is like Country
| Country | Records |
| India | 50 |
| China | 40 |
In this example, insights are, city column is null for 50 records of India country. So in similar fashion, I want to have such kind of break down for all 49(50-1) columns in one go and write them in a excel file automatically.
So final outcome will look like as:-
| Country | #Records | | State | #Records | | Region | #Records |
| India | 50 | | A | 60 | | C | 80 |
| China | 50 | | B | 40 | | D | 20 |
