Option to include all group-by fields in every row of export

Idea created by jbante on Apr 17, 2017
    Active
    Score20

    When exporting sorted records, FileMaker gives us the option to export one row per summarized group. When exporting with multiple summarized groups, the higher-order group-by fields are not repeated on each row:

     

    Group-By 1Group-By 2Summary
    aα40
    β26
    γ42
    bα12
    β97
    γ82

     

    This is fine for exporting data to be used by other applications. However, exports with grouped data are also useful for pre-calculating large summary reports. In this use case, not having the group-by values for all group-by fields repeated for all rows makes it difficult to retrieve the correct pre-built report records later. Either the values have to be added after the fact; or we have to do things on the export side like creating calculation fields for what each row would look like in CSV, then tell FileMaker to export that one field as .tab, but with a .csv file name. This would be easier to implement and faster to run if FileMaker just gave us the option to include all group-by fields on every row of an export:

    Group-By 1Group-By 2Summary
    aα40
    aβ26
    aγ42
    bα12
    bβ97
    bγ82