Max ascending by name output not to exceed 7 records?

[nihou]

Hello, 

I am trying to generate output files based on a key item, "Name".  I need to limit each output to 7 records.  I would also like the output file names to be numbered in ascending order by the key item as well.  I have attached a source document with output tabs, however I would like the output o be files vs tabs.

Max ascending by name output not to exceed 7 records

[Luke_C]

Hi @nihou 

Will any one 'name' ever have more than 7 records? What should happen in that case?

[nihou]

No it will never exceed 7, thank you!

[Luke_C · Accepted solution]

Got it, take a look at this method:

It will count how many records are present for each name, and the multi-row formulas put them into groups based on those counts. If the total count for the group exceeds 7 it places the name into the next group.

Then for the separate files, you can use the formula tool to derive the filename. For excel files, you'll need to choose 'change entire file path' and choose the new filepath column. This is currently set to output to wherever the workflow is saved, but you can adapt that. 

[nihou]

@Luke_C 

Thank you! This worked, appreciate your help!