7 Replies Latest reply on Oct 9, 2012 5:23 AM by user12837

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


      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.