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?
Solved! Go to Solution.
awesome, thank you so much!