Select Records - up to certain unique named value

[dataviolet]

Hello all,

I have an input data that looks like this:

Item Description	Amount
item 1	#
item 2	#
item 3	#
subtotal	#
more items	#
more items	#
more items	#
more items	#
total	#

The input file constantly has more rows added to the file, that roll up into the subtotal/totals. How do I formulate a Select Records tool to only select up to the subtotal row, and ignore everything after the subtotal, given that there will constantly be rows added or removed to the input file?

[BrandonB · Accepted solution]

Here is an easy approach. You make a flag with a formula tool followed by a running total, and finally a filter to isolate the desired records. Workflow is attached for your reference. 

 

[dataviolet]

awesome, thank you so much!