3 Replies Latest reply: May 15, 2014 10:06 AM by Data Kruncher RSS

    Populate Blank Field With Prior Value

      In a DBF there is a Description field that has a value at the beginning of a set of data.  The discription is needed to autofil until the data set changes.  For example:

       

      The catagory is blank for this record.  I would like to have the Catagory from the previous record fill in.

       

      Currently Data Looks like this:

       

      ACCT.   AMT.   Catagory

       

      1234   $12.50  Revenue

      1256   $25.60                                 

      "

      "

      2123   $15.00  MOB Expenses

      2345   $14.65 

       

      It should look like this:

       

      1234   $12.50  Revenue

      1256   $25.60  Revenue                                                                           

      "                                                                               

      "                                                       

      2123   $15.00  MOB Expenses

      2345   $14.65  MOB Expenses

        • Populate Blank Field With Prior Value
          Data Kruncher

          Hi Dr.,

           

          There's a theme today it seems with data sharing between records when using database sources.

           

          Accordingly, I have a two pass solution to recommend.

           

          First, open your DBF file as you do normally. Build and run a project export from the Table windows to create a fixed-length text file. In effect, this will output the Table as a report file. Save the model and the project files for later reuse.

           

          Now open the new text file as a conventional report and model it, employing the "Copy value from previous record" mechanism in the field properties. Again, save the model (and project if desired).

           

          That ought to do it.

           

          HTH,

          Kruncher