Subscribe Bookmark RSS Feed

Column filling

Onjai

Occasional Contributor

Joined:

Jul 12, 2017

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

Joined:

Jun 23, 2011

Solution

Try the Sequence() function.

 

JMPScreenSnapz137.png

JMPScreenSnapz139.png

JMPScreenSnapz138.png

 

 

-Jeff
4 REPLIES
Onjai

Occasional Contributor

Joined:

Jul 12, 2017

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

Thank you

uday_guntupalli

Community Trekker

Joined:

Sep 15, 2014

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

Joined:

Jun 23, 2011

Solution

Try the Sequence() function.

 

JMPScreenSnapz137.png

JMPScreenSnapz139.png

JMPScreenSnapz138.png

 

 

-Jeff
Onjai

Occasional Contributor

Joined:

Jul 12, 2017

Jeff,

Thank you.  Sequence worked perfectly.

Cheers!