Choose Language Hide Translation Bar
Onjai
Community Trekker

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

0 Kudos
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
Community Trekker

Re: Column filling

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

Thank you

0 Kudos
uday_guntupalli
Community Trekker

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
0 Kudos
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

Highlighted
Onjai
Community Trekker

Re: Column filling

Jeff,

Thank you.  Sequence worked perfectly.

Cheers!

0 Kudos