Need help in customize filter.

[anonymous008_G]

Hi,

How can I filter below data that will get output as EMG and very next record of EMG, rest everything should be filter out. Can we do this with filter block or multi row formula needs to be use?
Can someone please help me with solution.

Sector

Long

Long

Long

Long

Long

Long

Long

Long

EMG

Long

Long

Long

Long

Long

Long

Long

Long

[OTrieger]

@anonymous008_G 

I do not understand what you would like to do. With a Filter Tool you can filter out all the EMG entries from the rest. But I'm not sure what you are trying to do as it is not clear from what you wrote.

[OllieClarke · Accepted solution]

Hi @anonymous008_G 
You'll need both a multi-row formula tool and then a filter

Create a flag field with

[row-1:field]='EMG'

And then your filter is 

[Field]='EMG'
OR [Flag]=1

[anonymous008_G]

@OllieClarke -- thanks, this is worked as per my expectation.