7 Replies Latest reply: Sep 16, 2016 2:37 PM by Jason Duryea RSS

    Text Field with Index Numbering by Group

    Jason Duryea

      I'm trying build a table similar to the following. I have everything built except for the Name field which is supposed to be a concatenation of the Type field plus an incremented number. The incremented numbering should reset to 001 on each grouping of Project # & Type.


      The question is...How do process the existing table containing Project #, Type, Variable Date and Amount to include the Name field with the incremented numbering scheme?


      I'm building this within the script of our data model. This is not being built on the front-end application.


      NOTE: This table has no relevant usage within QV. We're trying to build a temporary table for export to .csv format for use in another application.