Filtering a single row and include the top and bottom 10 rows

Hello,

I am trying to filter on a single row and include the bottom and top rows next to it as a block.

For example this is an xml of a workflow and I want to filter criteria based on row 110 where it includes (BC) and make it include the bottom and top 10 rows next to row 110.

I will need to use a mutli row formula but need to keep the values exactly the same or it will mess the xml in the cell...is there a way to do that ? Then I can assign a tile tool of some sort if i need to.

xml filter pic.png

Workflow

Developer

Custom Tools

Accepted answers

MatthewO

@Carlos_Tovar the revised example uses a reference table to find a list of values.

IdentifyRowGroupings_v2.yxzp

All comments

dsandmann

To keep it simple - you could do the following:

Use filter tool that filters on RecordID >= 110
On the True anchor use a sample tool for bottom 11 records
On the False anchor use a sample tool for top 10 records
Union the two with the bottom 11 as input #1

MatthewO

@Carlos_Tovar attached is an example of how this can be accomplished. The current workflow only looks forward and backward by 2 rows out of convenience, but you could modify that logic in the Formula tool. I hope this is helpful!

IdentifyRowGroupings.yxzp

Carlos_Tovar

This works for (BC) but I have have 92 tools that go from (A) to about (CM) so that lone filter tool would not cut it.

Is there something that can dynamically read the Ids like (AA) for example and give me a block of code for each ID containing the 10 roes above and the 10 rows below ?

This script is 25k lines long

Carlos_Tovar

That was just an example and I need something Dynamic that can match the ID (AA) or (BC) for example there are 92 IDs and give be a block of code 10 rows before and 10 rows after it.

MatthewO

@Carlos_Tovar the revised example uses a reference table to find a list of values.

IdentifyRowGroupings_v2.yxzp

Carlos_Tovar

Nice this worked thanks

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703