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

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

    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