Conditional Row Count in Straight Table

[shamiul_islam]

I created a straight table where I show Customer wise Sales, Outstanding and Return amount with condition like greater than or less than. But row no are not sequential like 2,4,6. But I want into 1,2,3 sequentially. How can I do that?

If anyone know help me.

Thanks in advance 🙂

[Vegar · Accepted solution]

Try one of these two solutions.

Load 

Alt(peek('NewRowNo'),1)+1 AS NewRowNo

*

From Data;

OR

Load 

Autonumber(RowNo) as NewRowNo,

*

From Data;