Filter RecordIDs by multiple start/end values

[NickKierstead]

Hi, all, not sure if this can be done in-line or with a macro, but I am trying to filter out specific lines/RecordIDs in a set of data. The Start/End lines are generated at run time. 

Group	StartLine	EndLine
1234	1	10
1234	30	40
4321	11	29
4321	41	50

I wrote a batch macro that uses the start/end lines to pass through a filter, to separate the groups, but the results are not clean due to how it iterates. My goal is to generate two mutually-exclusive lists from one source (50 lines in this example) based on the start/end line table above. Every line indicated between the start/end lines for group 1234 would be one output and all the lines for 4321 would be the fail or another output. Thanks, in advance!

[RogerS]

You can use the generate rows to create the additional lines and then filter.  

[NickKierstead]

Thanks, I am not sure how that might be applied, below is a schematic of my current macro and the macro itself, plus a project that hopefully shows how I am intending this to work.  Not sure why all the record IDs are getting through.

[Hamder83 · Accepted solution]

hi @NickKierstead  im not sure I know exactly what you want, but could this work? 

[NickKierstead]

That worked with some modification and very elegant use of that tool. Thank you!