Mutiple columns Checks

Question

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

CountryRecords India 50China40

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 A60 C80China50 B40 D20

Vikas038 · Answer

Hi Dan,

You can consider the below information as sample file.

I hope this helps.

CountryRegionStateCityIndia ASIAHaryanaNULLIndia ASIAHaryanaNULLIndia ASIARajasthanJaipurIndia ASIARajasthanJodhpurIndia ASIARajasthanNULL

Thank you

danilang · Answer

Hi @Vikas038

Can you include a sample input file that includes all the columns of interest.

Thanks

Dan