441555_en-US

liliconcom

How can I find the result without looping?

For example, the number of piles according to the height value greater than 63:

 

This heap number refers to: when the number of adjacent rows is more than 63 consecutively, the count is 1, so the count should be 8.

The result can be obtained in a circular way, please ask if there are other ways to get the result. Thanks!

 

ScriptingRe: 如何能不用循环的方式求出结果？

Maybe something like this:

If(Row() == 1, cur_val = 1);
If(:height > 63 & Lag(:height) <= 63,
 cur_val
 ++);

Re: How can I get the result without looping?

When the amount of data is large, the time-consuming methods of the two experts are quite different. Thanks again!