Mark intervals between an N and P flag with a buffer of X columns

Question

Hi all,

I have a data set with specific N and P flags in a column. I would like to isolate/mark (with a 1) the rows in between NP flag pairs only when the P flag occurs after a minimum of 6 rows, inclusive of the N flag row. Only an N flag after a P flag will create a new isolation interval.

ValueFlagMark234N1234 123N14P1458 145 18P158  567P ...   N1  1 P1  1 N1  1 P1    N1  1  1  1  1 P1  1 P1

Any and all help would be appreciated. I tried using the filter tool with the multirow formula but I am having trouble figuring out the 6-row margin part. Thanks in advance!

Robin_McIntosh · Answer

Not sure if I'm following exactly what you're looking for but does this somewhat solve?  I acutally increment the mark and reset each interval.

Discussion Test.yxmd

Jay-RDC · Answer

You should be able to accomplish that using a Record ID tool first then use the Record ID as reference for your formula.