topic Re: Fill consecutive rows in Discussions

Fill consecutive rows

pankti — Sat, 10 Jun 2023 23:27:02 GMT

I have a large data set and will like to fill consecutive rows with top value.

Re: Fill consecutive rows

jules — Wed, 10 Mar 2021 12:40:44 GMT

You can use the "Replace Missing with Previous Value" function that is a part of the data table. Select the entire column, then right click the top value > Fill > Replace Missing with Previous Value.

I hope this helps!

@jules

Re: Fill consecutive rows

pankti — Thu, 11 Mar 2021 00:30:07 GMT

@jules, is this a feature in new versions of JMP. We are using JMP 13.2.1 and unable to update. Thanks

Re: Fill consecutive rows

Kevin_Anderson — Thu, 11 Mar 2021 12:31:46 GMT

Hi, pankti!

Try this formula:

Floor( (Row() - 1) / 4 ) + 1

Good luck!

Kevin

Re: Fill consecutive rows

jules — Thu, 11 Mar 2021 01:24:17 GMT

Hi @pankti,

Yes, this feature was added in JMP 14. With JMP 13 or earlier you have a few options:

use a script, or a column formula. This is discussed in this post:
use the , which adds this feature and several othersto your Add-Ins menu

I think you will find a lot of use from the Add-In, so that is my recommendation.

Julian

Re: Fill consecutive rows

jules — Thu, 11 Mar 2021 01:32:29 GMT

Good thinking, @Kevin_Anderson! I didn't even consider that the question might be less about spanning these values in general and more about creating a sequence. If this is the case @pankti, Kevin's already provided you one flexible option to create such a sequence. I'll give one more, which is to use the built in Sequence() function in a column formula. The syntax is:

For your situation, it appears you would use something like:

Sequence(1,99999,1,7)

That is, numbering from 1 to some value (high enough where you don't then start over), incrementing by 1 each step, and repeating each value 7 times before incrementing.

Julian