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.