Forum Discussion

PeterBartholomew1's avatar
PeterBartholomew1
Silver Contributor
Jun 30, 2022

Patrick2788 

I am not sure I fully understand the scenario and, it may well be that I am simply agreeing with Matt.  That said, I see that helper functions like MAP and SCAN may perform calculations element by element without there being an obvious means of addressing adjacent elements of the array.  In such a situation, my suggestion would be to scan an index array rather than directly scanning the target array.  Elements of the target array could then be returned by use of the INDEX function, e.g.

= MAP(indexArray, 
    LAMBDA(k, 
      AVERAGE(
        INDEX( targetArray, k+{0,1,2} )
      )
    )
  )

Am I on the right track?

 

Patrick2788's avatar
Patrick2788
Silver Contributor
Jul 01, 2022

PeterBartholomew1 

Yes, I think you and mtarler have it correct.  I have a way (SCAN with XLOOKUP using SEQUENCE for lookup array and return array) to reset sequential numbering (e.g 1,2,3,4,5,6,1,2,3, etc) but I don't believe it can be scaled for large data sets.

 

I still need to study your workbook from the destacking thread.  When I'm at my desk at work I don't have access to an Insider build so I'm missing out during typical working hours!

Resources