user12837

Script to Produce List: field name | non-empty record count

Discussion created by user12837 on Oct 7, 2012
Latest reply on Oct 9, 2012 by user12837

I inherited a table with 800+ fields, many of which have little or no data.

 

I would like to write a script which iterates through all the fields in this table, writing a record to another table with two fields:

 

-- field name

-- number of records having a non-empty value in that field

 

How should I perform the calculation in red?

 

One approach would consist of constructing a find on each field, but I don't know how to write a dynamic find.

 

Thanks,

 

Tom

Outcomes