Conditional Row Number

[poluvidyasagar]

Hi,

I am trying to achieve this Row Number function in the script.

Actual Data:

Product	Time
A	2/18/2019 6:45
B	2/18/2019 6:49
C	2/18/2019 6:45
D	2/18/2019 6:49
E	2/18/2019 6:52
F	2/18/2019 6:52
G	2/18/2019 6:55
H	2/18/2019 6:55
I	2/18/2019 6:59
J	2/18/2019 6:59

I would like to generate a row number in order of increasing time column. So the result should look like this.

Product	Time	Seq
A	2/18/2019 6:45	1
B	2/18/2019 6:49	3
C	2/18/2019 6:45	2
D	2/18/2019 6:49	4
E	2/18/2019 6:52	5
F	2/18/2019 6:52	6
G	2/18/2019 6:55	7
H	2/18/2019 6:55	8
I	2/18/2019 6:59	9
J	2/18/2019 6:59	10

I have this script:

Load 

Product,

Time,

RowNo() as Seq

From 

Data;

How do i put condition on the Row No() to get sequence in the form of time loaded.

I know we can do this using resident load. But any other way around this?

Thanks,
Vidya

[rwunderlich · Accepted solution]

I believe you will have to do a Resident Load with "Order By Time".  Only Resident supports the Order By. Alternatively, if you are loading the data with SQL SELECT you could put the Order By on the SQL. 

 -Rob
http://masterssummit.com
http://qlikviewcookbook.com
http://www.easyqlik.com