Need help in customize filter.

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

EMG

Long

Help

Accepted answers

OllieClarke

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

All comments

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

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.

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703