topic Re: Column filling in Discussions

Column filling

Onjai — Mon, 16 Oct 2017 20:36:33 GMT

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

Onjai — Mon, 16 Oct 2017 20:37:42 GMT

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

Thank you

Re: Column filling

uday_guntupalli — Mon, 16 Oct 2017 21:55:13 GMT

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 ?

Re: Column filling

Jeff_Perkinson — Mon, 16 Oct 2017 22:14:14 GMT

Try the Sequence() function.

Re: Column filling

Onjai — Tue, 17 Oct 2017 13:12:57 GMT

Jeff,

Thank you. Sequence worked perfectly.

Cheers!