cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
JMP is taking Discovery online, April 16 and 18. Register today and join us for interactive sessions featuring popular presentation topics, networking, and discussions with the experts.
Choose Language Hide Translation Bar
Onjai
Level III

Column filling

Hi,

I have a table of data containing several hundred rows and need to create a column that is filled with incremental numeric values, the twist is that I require the incremental fill to follow as below:  The column is called "sample" and row 1 value = 1, row 2 value = 1, then increment by 1, so that row 3 value = 2, row 4 value = 2 and continue to the end of the data file.

 

 sample
 1
 1
 2
2
 3
 3
 4
 4
 5

 

Any thoughts?
e 5
s 6
e 6
s 7

1 ACCEPTED SOLUTION

Accepted Solutions
Jeff_Perkinson
Community Manager Community Manager

Re: Column filling

Try the Sequence() function.

 

JMPScreenSnapz137.png

JMPScreenSnapz139.png

JMPScreenSnapz138.png

 

 

-Jeff

View solution in original post

4 REPLIES 4
Onjai
Level III

Re: Column filling

Please ignore the last few lines of my post...those should not have been sent.

Thank you

uday_guntupalli
Level VIII

Re: Column filling

You should be able to use Lag() function to get what you want .

Can you provide a screenshot of the exact output you are after ?
Best
Uday
Jeff_Perkinson
Community Manager Community Manager

Re: Column filling

Try the Sequence() function.

 

JMPScreenSnapz137.png

JMPScreenSnapz139.png

JMPScreenSnapz138.png

 

 

-Jeff
Onjai
Level III

Re: Column filling

Jeff,

Thank you.  Sequence worked perfectly.

Cheers!