Fantastic contribution thank you @brady_brady! Perfect for us non-scripters out there who need to corral messy data and who use the JMP GUI routinely as the "tool of choice." @PatrickGiuliano I did not know of the "cumulative sum" trick to sequence data within a group, and I also never thought to use reverse indexing like you did for this!
Great usage of cumulative sum. Thanks for sharing.
How does one create a sequence in JSL? For example, row 1 = 1, row 2 = 2, row 3 = 3, row 4 = 4 and row 5 = 5....row 6 = 1, etc....
Thank you a non-scripter and I am sure that I will keep replaying this until it becomes more natural for me!
Extremely helpful video for beginners like me, thanks for posting!
good reminder with some interesting news for me
The second cumulative sum trick*****
cool trick by @brady_brady at 12:45min:select some rows via Select Matching Cells - then select the right column and paste the values.I use it very often with the left/right arrow keys. It's wonderful that the row selection stays there - independent of the column selection. I hope this feature gets never remove from JMP.
