Increment a number field

[Anonymous]

Hi guys,

I have a field called unique_id. 

I would like to add one to this column per row like this

153480

153481

153482

153483

153484

and so on...

Is this possible in an expression? Or another way?

Thanks

[sunny_talwar]

May be:

RangeSum(unique_id, RowNo())

[Kushal_Chawda]

Create a straight table

Dimension - Unique_id

Expression - concat( bin_code,',')

[swuehl]

RangeSum(unique_id, RowNo()-1)

[sunny_talwar]

Thanks you for fixing the expression

[Anonymous]

Thanks for your help so far guys.  None of these has worked so please keep going!

[sunny_talwar]

Would you be able to share a sample?

[Mark_Little]

HI,

Could address in script?

IF( Rowno()= 1, Unique_id, Previous(Unique_id) +1) as Unique_id

Of

IF( Rowno()= 1, Unique_id, 

     IF( Unique_id =Previous(Unique_id), Previous(Unique_id)+1) as Unique_id    

Mark

[maxgro]

unique_id + RangeSum(Above(sum(1), 0, rowno()))-1

[Anonymous · Accepted solution]

Thanks for all your help guys.  I have figured out a way to do this.

In my load script I created an extra field

RowNo() as 'row_num'

I then created an expression which adds the unique_id to the row_num field

=unique_id + row_num

I wouldn't have figured this out without your help so thank you very much again