46021_en-US

liliconcom

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

Re: Column filling

Jeff,

Thank you.  Sequence worked perfectly.

Cheers!

Re: Column filling

Try the Sequence() function.

 

 

 

Re: Column fillingYou should be able to use Lag() function to get what you want .

Can you provide a screenshot of the exact output you are after ?Re: Column filling

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

Thank you